Using MS ACCESS 2000 - I'm trying to build a form based on tables that I created. I have 3 fields, and basically what I want is to enter the cpt code field, and have the other two fields automatically populate based on the data in those tables (CPT Fee, and CPT Desc)
I read through other questions and answers, but I couldn't find exactly what I'm looking for. A lot of what I found on your site was about combo boxes.
My form is just three text fields. I made the control source match the tables.
Here is a sample of my tables:
Table 1 - CPT Codes
Field name: CPT Code
Table 2 - CPT Desc
Field names: CPT Code
Table 3 - FEE
Field names: CPT Codes
I created a relationship from Table 1 CPT code to the CPT code on the other two tables.
What do I need to do to get my form to work the way I want it to. I want to enter only the CPT Code, and then have the other two fields (desc and fee) automatically populate with the data I have loaded in my table(s).
Anyhelp you can provide would be much appreciated. Thanks!