Autopopulate a Criteria in a Report

[pbaldy]

I ran your query and entered dates that had data. I don't believe I changed your query at all. See pic

 

[rkrause]

I got that to work, thanks.
How would i put the criteria in the querey for the begining date and ending date, so that i can use textboxes on the form?

right now in my querey i have Between [Beginning Date] and [Ending date]

so my question is how would i use that in a criteria with 2 text boxes on the form. Thanks.

 

[pbaldy]

As you did before, replace each set of brackets with a form reference pointing to the appropriate textbox.

 

[rkrause]

So like this?

Between [Forms]![frmLocation].[textbox1] and [Forms]![frmLocation].[textbox2]??

 

[pbaldy]

Yes; did you try it?

 

[rkrause]

I have it set up the way i think it should be, but in a textbox i cant figure out how to bound it to a field like the combobox. there isnt that option wiht a textbox. All i see is the control source, and i did that and it dint work.

 

[pbaldy]

Didn't work in what way? For both a combo or textbox the control source is what binds it to a field. With criteria forms like this, you often don't bother having the form/controls bound to a table anyway.

 

[rkrause]

Sorry i got this figured out. I forgot to post back. Thanks for all the help.