I need to be able to use the values in TABLE "tblLimits" to format fields of a FORM "frmInsCon" that is based on TABLE "tblInsCon". I will explain the best I can.
tblLimits - Contains minimum values necissary for compliance. Each record is a different set of limits and has a number in the key field to identify the limit set.
tblInsCon - Contains the main information of the database. It houses insurance records that need to have a minimum amount of coverage to be in compliance.
frmInsCon - An entry form to enter data in to tblInsCon. When data is entered into any of the amount fields I want it to check the tblLimits to make sure the amount meets the minimum requirements for compliance. If it does not I want the amount to turn red and go bold.
I can get this to work if I "HardCode" the amounts in the vba code but I need to be able to use different sets of limits for different types of insurance claims. My problem is that I don't know how to referece the data in tblLimits from frmInsCon in VBA
Any help would be much appricated
Thanks
tblLimits - Contains minimum values necissary for compliance. Each record is a different set of limits and has a number in the key field to identify the limit set.
tblInsCon - Contains the main information of the database. It houses insurance records that need to have a minimum amount of coverage to be in compliance.
frmInsCon - An entry form to enter data in to tblInsCon. When data is entered into any of the amount fields I want it to check the tblLimits to make sure the amount meets the minimum requirements for compliance. If it does not I want the amount to turn red and go bold.
I can get this to work if I "HardCode" the amounts in the vba code but I need to be able to use different sets of limits for different types of insurance claims. My problem is that I don't know how to referece the data in tblLimits from frmInsCon in VBA
Any help would be much appricated
Thanks