If statement????? 1

[BT24]

I want to write an If statement that looks up information in a query. what it does is that in the original query the criteria is based on the Area. there are 3 areas. now when they input the area i would like the specific information about that area to come up on a form in combo boxs. the information that comes up are just locations in that area and the operators in the area. Thanks for whatever help you can give.

iamuseless

 

[danvlas]

Set the row source for each combo box dependant on the [area] control ("Where Area = Forms![YourForm]![Area]&quot. Requery all combo boxes or the entire form upon the AfterUpdate event of the [area] control.

Sub Area_AfterUpdate()
combo1.Requery
combo2.Requery
'...
End Sub

or

Sub Area_AfterUpdate()
Requery 'this is for the entire form and recreates form's recordset
End Sub

HTH,

Dan

 

[BT24]

Thanks Dan
you were a big help