hi.. some help please.. on my form there i a cascading combobox with 2 cbxes, the 1st is homestate and the 2nd is homecity.. there's a textbox for area after the comboboxes, where the user will enter an area from street address..
i need to open a report according to the area that the user entered.. meaning that first he will choose the state, and then the city, and finally entering an area in the textbox.. and the report will display only the record that matches all three..
i have no problem with the combobox.. but when i entered the area, an access pop up msgbox will ask for me to enter the street address value..
this is the code that im currently using.. any suggestions?
Dim strLocHome As String
strLocHome = "HomeState = Forms![ReportPage]!HomeStateCbx AND HomeCity = Forms![ReportPage]!HomeCityCbx AND HomeAdd Like " & Chr(34) & "*" & Forms![ReportPage]!AreaTxt & "*" & Chr(34)
i need to open a report according to the area that the user entered.. meaning that first he will choose the state, and then the city, and finally entering an area in the textbox.. and the report will display only the record that matches all three..
i have no problem with the combobox.. but when i entered the area, an access pop up msgbox will ask for me to enter the street address value..
this is the code that im currently using.. any suggestions?
Dim strLocHome As String
strLocHome = "HomeState = Forms![ReportPage]!HomeStateCbx AND HomeCity = Forms![ReportPage]!HomeCityCbx AND HomeAdd Like " & Chr(34) & "*" & Forms![ReportPage]!AreaTxt & "*" & Chr(34)
