Hi
I'm a bit new to Access, however I created what I think is a fairly complex database and now preparing some reports. I want to have a drop down option for one report and from reading through these forum I know I need to link a form to the report and link the form to a query.
The problem I have is I cant get the form to run the chosen data against the query. The combo box looks up 5 different values and I can choose the value I want then click the command button which does run the query, although the datasheet I get back is blank.
If I run the query itself it comes up with the parameter box and if I type one of the values it does correctly display the records. I have set the criteria of the query to be [Forms]![Assettypeform]![Combo2] which I believe should tell it take the value of the combo box of the required form called Assettypeform.
Please help me.
I also should point out I'm using access 95 as my company are cheapskates.
I'm a bit new to Access, however I created what I think is a fairly complex database and now preparing some reports. I want to have a drop down option for one report and from reading through these forum I know I need to link a form to the report and link the form to a query.
The problem I have is I cant get the form to run the chosen data against the query. The combo box looks up 5 different values and I can choose the value I want then click the command button which does run the query, although the datasheet I get back is blank.
If I run the query itself it comes up with the parameter box and if I type one of the values it does correctly display the records. I have set the criteria of the query to be [Forms]![Assettypeform]![Combo2] which I believe should tell it take the value of the combo box of the required form called Assettypeform.
Please help me.
I also should point out I'm using access 95 as my company are cheapskates.
