I tried earlier and no one has answered so I thought I would try explaining it different. I have looked at the other examples but still no joy.
I have 2 table in one DB (Access)
Table1 is empty and will be populated when a form is filled out.
Table 2 has only 2 columns Provider Code and Provider Name.
This table is full of all names of clinics and the respective clinin codes. 901 in total.
Now I have a FORM which is the same field names as the table it relates to.
In this form I have Provider Code and Provider Name as 2 of the fields amongst others. I want the user to be able to type a name of a provider or from the drop doen box. Once selected the Provider Code field will populate with the correct Provider Code.
Please help.
I have 2 table in one DB (Access)
Table1 is empty and will be populated when a form is filled out.
Table 2 has only 2 columns Provider Code and Provider Name.
This table is full of all names of clinics and the respective clinin codes. 901 in total.
Now I have a FORM which is the same field names as the table it relates to.
In this form I have Provider Code and Provider Name as 2 of the fields amongst others. I want the user to be able to type a name of a provider or from the drop doen box. Once selected the Provider Code field will populate with the correct Provider Code.
Please help.
