Requery one subform from another

[a.t.brooks]

Hi guys,
I have a combobox on a subform within a subform on a tabbed control on
a mainform. The content of this combo box is "Username" and determined
by a username field in a users table. That users table can be appended
using another subform on the mainform.


Does anyone know the requery code so that if I add a record to the
table, the combobox will automatically be updated so that the new
record is available to select in the combo box?

Tony

 

[a.t.brooks]

Hiya
I figured it out.
I was going about it in totally the wrong way.
I just stuck a Requery in the OnGotFocus event on the combobox.
I can be a bit of an idiot sometimes ;o)