You'll need a Number field in the table, called Filter. Place a 1 or 2 next to each name, depending on which list they belong to. Reason: Option buttons return an integer response by default.
Now, the pick list on the form. The control needs to be a Combo box. If it's not already, right-cllick the control in Design view and Change To | Combo Box. BTW, the field that this combo links to (its Control Source) needs a change in data type. It should be a Number, Long Integer. (Combos work on ID fields, which are usually Autonumber)
Go to the Row Source Type property (in the All tab) and select Table/Query
In the Row Source, click the ... button and build a query. You'll need the ID field for the table, the Name field, and the Filter field.
In the criteria for the Filter, place the name of the Option Group that contains your buttons -- FrameXX, where XX is the control number
Close the grid, save changes.
Now to set the columns in the combo. Adjust Column Count to 3, and the Column Widths to 0;3;0 -- this ensures that you see the Name field. Bound Column should be 1, the ID field.
Finally, when you select the option button you want the lisst to update.
Right-click the frame of the option group. Go to its Properties, Events tab, After Update event. Double-click this line. You'll see [Event Procedure]. Now click the builder (...) on that line to go to the code. Enter this line:
[Enter the name of your combo box].Requery
Give it a test drive...
Denis
