Fill in Fields Based On Contents of Another Field

[batowl]

I have a database where I am entering data into a table (Table A) through a form.

Table A is full of patient information, then there are several empty fields relating to the patient's doctor's information (name, doc's address, phone, etc).



There is also a Table B, which is not on the form, but is full of information on all the doctors who the patient could possibly see.

What i would like to do is be able to choose the doctor's name from a drop down list in table A (which I have accomplished), and then have the rest of the doctor fields (address, phone, etc.) populate based upon that choice I just made from the drop down list. I know this must be possible, but I have not been able to figure it out. Any suggestions?

[TheShabz]

create a SELECT query that pulls all the data you want. In each of your controls, enter =DLookup("[fieldName]","queryName","[doctorID] = Forms!FormName!comboBoxName")

Change "[fieldName]" depending on the field you wish to populate (name, address, etc)

[pbaldy]

Does this help?

http://www.baldyweb.com/Autofill.htm