Kysteratwork
Technical User
Hi,
I am trying to find a template for an idea:
Situation: I have a contacts database tblcontacts and a companies database, tblcompanies. When I enter a new name in the contact database (frmContacts), I would like to allocate a company (and the address and web site, etc details that goes with it) to this contact.
I would like to create a pop-up form, from which I can do a search for the company. The form could have two main items, a dropdown and a listbox. I should be able to chose a company from a dropdown and the since a company can be present in various cities, I would like to see all the street names and cities where the company may be located in the listbox. Like this I could double-click on the row with the street name, which then populates the company field (and the respective address) in the frmContacts. It could also be done with two dropdowns, I guess.
So, the result of one dropdown determines the list of values in another dropdown (or listbox).
My programming skills are quite limited. Would you maybe know of a template I could adapt to this purpose??
Thank you in advance for your thoughts!
Regards,
Kysteratwork
I am trying to find a template for an idea:
Situation: I have a contacts database tblcontacts and a companies database, tblcompanies. When I enter a new name in the contact database (frmContacts), I would like to allocate a company (and the address and web site, etc details that goes with it) to this contact.
I would like to create a pop-up form, from which I can do a search for the company. The form could have two main items, a dropdown and a listbox. I should be able to chose a company from a dropdown and the since a company can be present in various cities, I would like to see all the street names and cities where the company may be located in the listbox. Like this I could double-click on the row with the street name, which then populates the company field (and the respective address) in the frmContacts. It could also be done with two dropdowns, I guess.
So, the result of one dropdown determines the list of values in another dropdown (or listbox).
My programming skills are quite limited. Would you maybe know of a template I could adapt to this purpose??
Thank you in advance for your thoughts!
Regards,
Kysteratwork