refreshing a combo box

aymanmb

Registered User.
Local time
Today, 21:09
Joined
Jan 28, 2007
Messages
96
I have a combo box that is linked to product name and should allow the user to pick the product name.

this combo box is reading from the product table, but when I add a new product name, the name does not appear in the form combo box unless I close the form and open it again.

I understand that I need to refresh the form or do a requery but not sure how while the form is open. I mean this is the main application form and is open all the time and I add a new product from another form that pops up on a command button on the main form.

thanks
 
In the code that lets you add a new product, after adding the product, put in

Forms!YourFormTheComboBoxIsOn.YourComboBoxNameHere.Requery
 
I did a quick search using "update combo after entry" and got about 20 responses back for it. Hmmmm.
 
I did a quick search using "update combo after entry" and got about 20 responses back for it. Hmmmm.

{Sarcastic mode on}This forum has a SEARCH feature??? Amazing!{Sarcastic mode off}
 
{Sarcastic mode on}This forum has a SEARCH feature??? Amazing!{Sarcastic mode off}

I know, Bob. It boggles the mind, doesn't it? Someone can actually go to the Advanced Search feature - type in a few key words and get all those answers. Absolutely AMAZING ;)

I might even try that sometime.
 

Users who are viewing this thread

Back
Top Bottom