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
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