I have a table with two fields, field1 is Company and Field2 is Company address. I am using a form to for sales requests that is linked to the table. I have a combox1 on the form that is for Company name and combox2 that is for company address. When I select the first combo box (company name) I want the second combo box (company address) to autopopulate the address field on my form. Your tips are much appreciated...!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Combo Box 1
- Thread starter ncinelli
- Start date
-
1
- #2
Hi
You could store the address information in a column in the first combo box and use:
[tt]=Me.cboCombo1.Column(1)[/tt]
For example, as the Control Source for a textbox, or to select an option in the second combo, but I think it would be best to use a text box.
Alternatively, you will find a lot of informtion on DLookup in the FAQs.
You could store the address information in a column in the first combo box and use:
[tt]=Me.cboCombo1.Column(1)[/tt]
For example, as the Control Source for a textbox, or to select an option in the second combo, but I think it would be best to use a text box.
Alternatively, you will find a lot of informtion on DLookup in the FAQs.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question