Multiple control update from one drop-down box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to offer a multiple column combo box drop-down in one control on
an ACCESS form and have it automatically insert the other column data into
several respective controls on the same form in the same user step.
 
One option would be to use an equation in the Control Source of the other
controls (textboxes).

Example:
=cboMyCombo.Column(1)

The column index number is zero based. This means that 0 is the first
column, 1 is the second, etc. Doing this will have the values in the other
columns display in the textboxes, but they won't be editable.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting combo box drop-down list 1
Drop Down Box 7
Combo Box in 2007 changes other combo box background 4
Copy record in one form into a new pop-up form 0
Restrict Choice in Shared WB (drop down alternative)? 0
drop down box issues 1
combo-box drop down list not updating 1
Control Source Dependent on Combo Box 2

Back
Top