refresh a combo box

Z

Zedbiker

I have a wildcard search operating on a Combo box. I use a parameter query
pop up box. Once I have operated the query once by clicking on the combo box
I have to refresh the form to be able to do another search. I would like to
be able to use a command button to operate the wildcard search and put the
answers in the Combo box. I am using Access 2002.
Looking forward to any help you can provide.
 
T

Tatakau

Not a difficult job to change the contents of a combo box.

There are a number of properties for a combo box that you can set. Row
Source is probably the most important one you want to focus on, which
contains SQL to select what to display. If you need to change this,

me!combobox1.rowsource = "SELECT * FROM items WHERE quantity > 0"

or whatever you want it to be. this won't change the contents of the combo
box though. to do that:

me!combobox1.requery

That should do it!

hth,

Nick
 
Z

Zedbiker

Thanks Tatakau
I didn't think it would be a difficult thing to do but I just couldn't find
the information I wanted in help files etc..
That will work.
Thanks again
Zedbiker
 
Top