Holding values in a form

[chancer1967]

Firstly, thanks for all the help I have had so far - I am starting to understand what I am doing now!


Now for today's issue


I have a set of queries that create aging data for customer balances (I need to figure cross-tab queries to improve how they work, but thats another project) and I have created a form for the user to set the start and end dates for each of five aging bands.

eg for period 1 they might enter 01-Jun-04 and 30-Jun-04 as the start and end dates. The queries then refer to the dates in the form as their criteria and it all works fine.

however... every time I open the form it has blank fields. I got round that by setting defaults values, but they are kinda spurious. what I actually want is to have the dates that were last entered, since the user will only change the dates once or twice a month.

I guess I am asking how I would either
- keep values in a form when it is closed; or
- set the default values as the current values when the form is closed (presumably with a macro or VBA)

thanks in advance!

 

[chancer1967]

That was more obvious than I had hoped!!

The form is now linked to a table with all the fields I need and only one record