Form Problem?

[Timbo57]

I have a rental database. I want to use a query with the start date to use for a report. I made a form with unbound txt boxes and a button to run the report. Everything works exept my form. If I run the query it ask for the start and end date and shows the records. It does the same with the report. If i use the form it just shows a blank report. Below is how i programmed the form and query. can anyone tell me why the report is blank when i use the form?

On my form, I put two unbound text boxes. Let's call them txtStartDate and txtEndDate
2. In My query, in the Date column, I put the following criteria expression...

CODE
Between Forms!frmReportSelect!txtStartDate And Forms!frmReportSelect!txtEndDate

 

[scoobypaw]

I am not sure if this makes a difference or not. But I have the same type of thing in my database and this is how I would write it:

Between[Forms]![frmReportSelect]![txtStartDate]And[Forms]![frmReportSelect]![txtEndDate]

 

[Timbo57]

Thanks for the information, but that came up with the same results. a blank report.

 

[PHV]

Does txtStartDate and txtEndDate already contain valid values at the time the report is launched ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

[blue]If I run the query [purple]it ask for the start and end date[/purple] and shows the records.[/blue]

This is an explicit indication that the [purple]form references are not available[/purple]. Possible causes:
[ol][blue][li]The form is not open.[/li]
[li]Something is misspelled or wrong naming.[/li][/blue][/ol]
The criteria in your post origination should work otherwise, and it should automatically be converted to that shown by [blue]scoobypaw[/blue].

See Ya! . . . . . .