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