By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,852 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

Query Table Info from Field List

P: n/a

I am trying to create a field on a form with a list. When the data from the
list is selected (Company Name), I want the rest of the fields on the form
to update with all of the info from that Company Table.

Help !
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Use unbound fields for all the company information. then if you add a
column to your combobox for each field you want to show in your form,
you can just reference the hidden fields. Covered really nicely in

Say your combobox, cboCompany, has 4 fields: companyID, company name,
city, state

You'd have text fields and the rowsource would be
=cboCompany.Columns(1) 'company name
=cboCompany.Columns(2) 'city
=cboCompany.Columns(3) 'state

(the listindex for a column is zero-based, so the first one,
CompanyID, is cboCompany.columns(0).
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.