MS Access: Passing values from a form to a parameter query

[NoLimit]

I'm trying to pass values entered from textboxes in a form to a parameter query. The problem I'm having is that when I try to run the query from the the form, it asks me to enter in values for the parameters instead of taking the values entered in the textboxes. I don't know what I'm doing wrong...

[Turnip12]

How are you trying to do it? I'm new to Access myself, so I'm sure someone else could give you a better answer. but one way might be to open up your form in design view, bring up the properties for the form(right click in the gray box in the top left hand corner of your form) set your query as the control source. Then go to each text box, bring up the properties, and set the control source to the matching field in the query.

[Creosote]

Edit the parameter query. If you have a form named Form2, and a TextBox name Text1 that has your parameter value, put the query crieteria like this:

[Forms]![Form2]![Text1]

[NoLimit]

Excellent. The form's working almost fine. There's just one more small detail. One of the paramters I have in the query is option and is supposed to return all records if nothing is entered, but when I use the form and don't enter anything for that paramter nothing is shown.. I already have the paramter set to "... OR [forms]![form2]![text1] IS Null. When I run the query byself, it works as it should.

[ctaylor]

Have a command button on the form to press after setting criteria in text boxes. the command box could call a test to check for empty parameters before running that will test to see if values are incomplete. You could either use the null test to call a message box and then exit sub, or you could try to autocomplete the values

The command button can run a test such as

if [Forms]![frmSearchCriteria]![txtStartDate].value is null and if [Forms]![frmSearchCriteria]![txtEndDate].value is not null then

msgbox "You must set a start date to run this report."
exit sub

Elseif [Forms]![frmSearchCriteria]![txtStartDate].value is not null and [Forms]![frmSearchCriteria]![txtEndDate].value is null then

msgbox "You must set a end date to run this report."
exit sub

Elseif [Forms]![frmSearchCriteria]![txtStartDate].value is null and [Forms]![frmSearchCriteria]![txtEndDate].value is null then

msgbox "You must set a start date and end date to run this report."
exit sub

Elseif [Forms]![frmSearchCriteria]![txtStartDate].value is not null and [Forms]![frmSearchCriteria]![txtEndDate].value is not null then

docmd.openreport "rptStartDate_EndDate_Report"

end if

[Brass]

Just thought I'd add a little something to this thread in the hope that perhaps it will save someone all the wasted time I spent trying to solve my problem...

I was having a similar problem accessing form controls for use in parameter queries. I couldn't for the life of me figure out what I was doing wrong. I was using the Expression Generator and it would still puke (Access kept asking me for a value for these parameters). After a lot of head scratching I finally noticed that the expression generator was giving me "[Formularios]![Form2]![Text1]" I'm working in Costa Rica and so using a Spanish version of Access 2002. For some reason, the expression generator seems to be talking Spanish but Access is still talking English. Argh!!! So once I changed the expression to "[Forms]![Form2]![Text1]" all was well.