I still need help with this. Can anyone offer suggestions?

[Infiltrator64]

What I am trying to do overall.

Main form has Begin and End date fields. A user will enter the begin and end date range they want to select records for based of off a close_date field on the records.

I want the dates the user enters to be stored in a table. I want these values to be the default value when a user reopens this form so they can see what date range the data was last updated with.

I want the query that selects the records to select records with a close_date between "The stored Begin Date" and "The stored End Date".

I am storing the begin date and end date values in a table called "Date Range"

I have a query that select records based on a range of dates for the case close. I use a parameter to prompt for a Begin Date and an End date. I then want to get the begin and end date values for the query from a table called Date Range. It contains two columns, Begin Date and End Date.

I can get this query to work right if I point the parameters in the query criteria to a form that have Begin Date and End Date fields linked to the Date Range table but I can't get it to recognize the values when I have the query criteria parameter look at the date range table to get these values.

I am using the following criteria in my close_date column of my query.
Between [Date Range]![Start Date] And [Date Range]![End Date]

When I try to get these values from the Date Range table it still prompts me for dates. I'm wondering if I need to specify a row some how? The date range table only contains one begin and one end date value.

Can someone help me figure this out?

 

[cpod]

Since there is only one record in the table you can try something like this:

Between dmax("[start date]","[date range]") And dmax("[end date]","[date range]")