Form field to auto pull data from a table when there is a match

[coyrob2010]

I have built a nice database that has a form to enter data which logs in product received, there is a combo box on the same form that is linked through the query builder to auto populate the names from the contacts info table (the receivers of the product received) the contacts info table also contains information that is specific to each name such as locations. As of now I have created a command button that brings me to the form that shows the information fields I need specific to a name, once I get that I have another command button to bring me back to the main form. I am asking for some help to create an additional list box on the main data entry form so as when the name is entered the new list box or text box (which is best?) will auto populate the information I need on one form instead of going back and forth.

Example:

Requester Name [ auto populate name ] currently linked to contacts info table (working)

(New field) Preferred Location [ need to auto populate location ] from the contacts info table (how do you pull locations specific to a contact name from the same table?



Thank you in advance.

Rob

[Amerlitong]

i would prefer to use listbox...
then try to put this SQL statement in your listbox recordsource properties...

SELECT location FROM contacts_info WHERE name = combobox

and create an On Click event in your combobox properties then select the event procedure and click the ...(three doted button)

type this code

Me.listbox.requery

i hope this will help...

Cheers

[coyrob2010]

Hi,

Is the On Click event in the combo box properties done in the [Requester Name] combo box? I tried this and as soon as I tabbed out of the requester name field the visual basic window opened displaying the code Me.listbox.requery.

Thanks again in advance.

Rob

[Amerlitong]

Hi,

Is the On Click event in the combo box properties done in the [Requester Name] combo box? I tried this and as soon as I tabbed out of the requester name field the visual basic window opened displaying the code Me.listbox.requery.

Thanks again in advance.

Rob

Thats right...create a Click event in your [Requester Name] combo box...and put this code Me.Listbox.requery


In your New Listbox recordsoure properties...type this SQL statement


SELECT location FROM contacts_info WHERE name = [Requester Name]

location,name fields and contacts_info table is just my assumption...it may defer into your actual database...

Cheers...