refreshing combo box

[Paul]

I have a form with a combo box on it. It pulls it's values from a query
that I know is working. The user is supposed to select a value from this
combo box(it displays available smart cards for computer login) and then go
to the next record and do the same. However, every time one of these cards
is chosen, it is not supposed to be available in the next record. If I run
the query, the smart card that has been choosen isn't there. However, on
the form, the smart card is still displayed. How do I get the combo box to
refresh itself based on the values of the query?

Thanks.

 

[Guest]

Hi Paul,

have you tried,
Me.myCombobox.Requery

if not thenconstruct the comboboxes code 'on the fly' when the form goes to
the new record.

TonyT..