Using A2003 w/ tables linked to SQL Server. All users have their own
copy of the mdb. I have a combobox whose rowsource is a query. This
query is based on a table and has a field in it that indicates if the
record has been selected. When user1 selects the record from the
combobox, the field is updated that the record has been selected. If
user2 tries to select that same record, they get a warning that user1
has selected it and they need to wait until user1 is finished. When
user1 is finished, the field is updated and user2 should now be able
to select the record.
My problem is getting the combobox to refresh after the field has been
updated. When user1 is finished with the record, the updated field
indicates they're not on that record anymore. But for user2, the
field indicates that user1 is still using the record.
This query is a union query that displays names in both "last name,
first name" order and "first name, last name" order.
I've tried requerying the combobox in the Enter, Click, and GotFocus
events. The only thing that works is closing the form and
reopening.
I assume this is a refresh problem since closing and opening the form
solves the problem. Where else can this combobox be refreshed?
Thanks for any help or advice.