Refresh Unbound Combo Box

  • Thread starter Thread starter jsccorps
  • Start date Start date
J

jsccorps

Have a combo box in a form "Client Sign In". The combo box "Combo78" is
unbound. When, I add Customer data, the data does not show on the Combo78s
drop down until I close and reopen the form. I've tried addiing
Me.Combo78.requery to the Combo78 On Got Focus event , but that does not
work.
Below is some Combo78 property data:
Control Source: <blank>
Row Source :SELECT Customers.ClientID, Customers.ContactLastName,
Customers.ContactFirstName FROM Customers ORDER BY Customers.ContactLastName;

Any ideas?
 
Have a combo box in a form "Client Sign In".  The combo box "Combo78" is
unbound.  When, I add Customer data, the data does not show on the Combo78s
drop down until I close and reopen the form.  I've tried addiing
Me.Combo78.requery to the Combo78 On Got Focus event , but  that does not
work.  
Below is some Combo78 property data:
Control Source:  <blank>
Row Source :SELECT Customers.ClientID, Customers.ContactLastName,
Customers.ContactFirstName FROM Customers ORDER BY Customers.ContactLastName;

Any ideas?
Click to expand...

Okay, that's weird.

Mine works fine. I added the Dropdown method just so that I could see
what's in the combobox's rowsource without all the fun clicking... and
it works fine.

Private Sub cboEmployeeID_GotFocus()
Me.cboEmployeeID.Requery
Me.cboEmployeeID.Dropdown
End Sub
 
Back
Top