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
Hi,

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 !
Kate
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
ADH2000.

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.