Requery one subform from another

  • Thread starter Thread starter a.t.brooks
  • Start date Start date
A

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
 
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)
 
Back
Top