i have a service code table of about 11,000 records on which i do calculations based on some values found there. i have another table that contains about 45 exceptions to the standard table.
basically i have an unbound combo box on a form that has the main table dynamically assigned as it's souce (based on other criteria). i need to know how i can check to see if the value picked in that combo box happens to appear in the exception table so i can then apply a different set of calculatin instructions.
i've tried everything i can think of and i think i'm about to go CRAZY! Any help would be most greatly appreciated!!!!!!!!!
basically i have an unbound combo box on a form that has the main table dynamically assigned as it's souce (based on other criteria). i need to know how i can check to see if the value picked in that combo box happens to appear in the exception table so i can then apply a different set of calculatin instructions.
i've tried everything i can think of and i think i'm about to go CRAZY! Any help would be most greatly appreciated!!!!!!!!!