I have a combo box calle comboIDType in my main form. The IDTYPE is string value. ("aa", "bb" , "ccc"). I would like when i select one type in the combo box, and click the get report button, it will retrieve all the record based on the IDType the user seleceted. I have a query call qryIDReport and report calle IDreport based on this query.
I have a question, how can i get the IDTYPE value that the user select?
In the get report event, i have the follwing code:
I have a similar problem, i am trying to use a combo box in a form to select various properties. upon selecting the property i want the report of that property to open. however, i have one report to deal with every property and so before thinking of this i used the report based on a query and used the "crieria" part so a message box would come up and i would need to write in the name of the property and the report would open. so now i need the correct property to appear using the input of the combo box.