Using combo box when adding records to continuous form


D

David

Hello,

I have a continuous subform with 2 fields in the table, field 1 (linked to
main form) and field 2 (the value I want to obtain from a combo box). Both
fields form the key.

What is the best way to:
1. Use the combo box to select valid field 2 values from a lookup table
2. Display other data from that lookup table on the subform (i.e. city,
state, zip).

The issues are:

1. The need to assign a value to field 2
2. The need to display other data on the subform from the combo box, but all
"records" on the subform then display those values.

Thanks.
 
Ad

Advertisements

R

Rick Brandt

Hello,

I have a continuous subform with 2 fields in the table, field 1 (linked
to main form) and field 2 (the value I want to obtain from a combo box).
Both fields form the key.

What is the best way to:
1. Use the combo box to select valid field 2 values from a lookup table
2. Display other data from that lookup table on the subform (i.e. city,
state, zip).

The issues are:

1. The need to assign a value to field 2 2. The need to display other
data on the subform from the combo box, but all "records" on the subform
then display those values.

Thanks.

Make your ComboBox have multiple columns containing all the data you want
to see from the lookup table. You have the option of showing these
additional columns in the drop-down list or hiding them by setting the
width of those to zero.

To display the additional colums on your form after a selection has been
made use TextBoxes with ControlSource expressions similar to...

=ComboBoxName.Column(2)
=ComboBoxName.Column(3)
etc..
 

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

Top