Requery Form from Combo Box

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.

try: me.requery

hth
--
Maurice Ausum


"Anthony Fontana" wrote:

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.

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" wrote in
message ...
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.

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" wrote:

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" wrote in
message ...
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.




.