Parameter Queries

[tinab]

I am using Access XP. I have properties table that has a date field.
I created a query using this table to make a new table called Merge
Data based on a date range. I have a date range form called "Report
Date Range". I put the following in the criteria in the parameter
query in the date field:

=[forms]![Report Date Range]![BeginningDate] And <=[forms]![Report

Date Range]![EndingDate]. I have a command button on a form that runs
this Query. The problem is the Access default parameter box appears
instead of my Report Date Range form. It works fine if I enter the
date range in this access parameter form but I would like use my form
to enter the date range not the default access one. What am I doing
wrong????

 

[Guest]

It might do that if your field names aren't typed in your query exactly
correct. Instead of the <>= Signs, try this...

Between [forms]![Report Date Range]![BeginningDate] And [forms]![Report
Date Range]![EndingDate]

I am using Access XP. I have properties table that has a date field.
I created a query using this table to make a new table called Merge
Data based on a date range. I have a date range form called "Report
Date Range". I put the following in the criteria in the parameter
query in the date field:

=[forms]![Report Date Range]![BeginningDate] And <=[forms]![Report

Date Range]![EndingDate]. I have a command button on a form that runs
this Query. The problem is the Access default parameter box appears
instead of my Report Date Range form. It works fine if I enter the
date range in this access parameter form but I would like use my form
to enter the date range not the default access one. What am I doing
wrong????