Requery Form from Combo Box


A

Anthony Fontana

I have a form with 2 combo boxes. Combo1 has values that restrict what
Combo2 shows. Combo 2 will be used after Combo 1 and simply reads the value
in combo1

When I open the form and select a value from combo1, combo2 works well. The
problem is that the form they are on needs to be requeried. I have tried
forms![MainFormName].refresh and that doesn't work.

How do I get the main form to requery after combo1 is updated.

Thanks.
 
Ad

Advertisements

L

Larry Linson

Check in Access Help or via online search for the difference between
..Requery and .Refresh -- they are not two words meaning the same thing.

Larry Linson
Microsoft Office Access MVP
 
Ad

Advertisements

A

Anthony Fontana

Me.requery didn't work. I solved the problem by taking the SQL from the data
property of the second combo box (chooses record for form) and putting it in
the data property of hte form. No records as shown initially, but that's OK
as user should select combo boxes first.

Thanks.




Larry Linson said:
Check in Access Help or via online search for the difference between
..Requery and .Refresh -- they are not two words meaning the same thing.

Larry Linson
Microsoft Office Access MVP

Anthony Fontana said:
I have a form with 2 combo boxes. Combo1 has values that restrict what
Combo2 shows. Combo 2 will be used after Combo 1 and simply reads the
value
in combo1

When I open the form and select a value from combo1, combo2 works well.
The
problem is that the form they are on needs to be requeried. I have tried
forms![MainFormName].refresh and that doesn't work.

How do I get the main form to requery after combo1 is updated.

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