refresh a combo box

G

Guest

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

Guest

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top