Requery Form from Combo Box

  • Thread starter Thread starter Anthony Fontana
  • Start date Start date
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.
 
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
 
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.
Click to expand...



.
Click to expand...
 
Back
Top