Combo box using parameter query refresh/requery how??

N

Nigel Cummins

Hi,

I am new to access vba programming. I have a subform which has a combo box
named "query" based on a parameter query.

The combo box works fine however I enter a value it looks up and give me a
result set. However, when I cycle to the next record in continuous forms or
in single view it still retains the same result set from the first query. I
want it to prompt me to enter the parameter again to get a different result
set.

I tried below and tried refresh but it didn't work.

Private sub lost focus ( )
query.requery
end sub

I press F9 for refresh at the moment and that works fine. It starts the
parameter again. What is the correct sub?

thanks
 

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