Using combo box when adding records to continuous form

[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.

 

[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..