Using Combo Box

[propolis]

This is very simple and I will possibly be very embarresed when I see the answer.

I have a form generated from table 1

I have a table 2 which contains the following:

Column 1 Column 2 Column 3
1 M Member
2 P Private
3 E Ex Member

On my main form (based on Table 1) I add a Combo Box.
This combo box displate the data from table 2
When selected either option 1, 2 or 3, it applies that choise to all the records in table one and not to that particular record only.

Any suggestion appreciated

 

[RuralGuy]

I suspect you are talking about a form in continuous form mode and the ComboBox is not bound to a field in the underlying query/table. If so, then that's the way it works! To get different results for each record you need to bind the ComboBox to a field in the RecordSet.