lsitbox requery problem

[JimmyRa]

I have a form based on an 'Events' table, with a (not enabled) list box displaying 'staff involved'. The rowsource is a query, which calls a VB function to get the current EventID, which is the key to both tables. There is an unbound textbox which can be used to add a staff member, using an SQL INSERT, with the EventID, and the StaffCode. This then does a requery, and the list box is updated.
Fine - looks good, and works well.
But if I go in to add a NEW event, the EventID is created, and then add Staff, the requery has no effect. The code is called, the proper EventID is sent, but the listbox remains empty! If you go off the screen, and check, all records have been added OK.

Any ideas, Please, anyone ?

 

[randy700]

It might help if you try Refresh instead of Requery when you add a new event.