Using combo box when adding records to continuous form

  • Thread starter Thread starter David
  • Start date Start date
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.
 
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.
Click to expand...

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..
 
Back
Top