Hi everyone
A friend just came to me with an Access related questions that has me curious. I think that I have seen what he is trying to do before but couldn't puzzle it out myself.
Here's the basics, he has two items on his form, the first is a drop down box and the second is a text box. The table that these two items are connected with has 3 fields (auto number, ARS, and description).
What he wants to do is link the two items on his form so that when an item is selected from the drop down box (from the ARS field) it will auto-fill the text box with the information from the description field of the same record.
Hopefully I explained this clearly. Can anyone out there be kind enough to provide direction on how to do this?
Any help would be appreciated!!!!!

A friend just came to me with an Access related questions that has me curious. I think that I have seen what he is trying to do before but couldn't puzzle it out myself.
Here's the basics, he has two items on his form, the first is a drop down box and the second is a text box. The table that these two items are connected with has 3 fields (auto number, ARS, and description).
What he wants to do is link the two items on his form so that when an item is selected from the drop down box (from the ARS field) it will auto-fill the text box with the information from the description field of the same record.
Hopefully I explained this clearly. Can anyone out there be kind enough to provide direction on how to do this?
Any help would be appreciated!!!!!