Unbound Date field to filter a report

[ste4en]

I have a start and end date field on a switchboard, this allows the user to select a date range to filter a report. I am using an unbound text box to hold the start and end dates, however this requires the user to reenter the date every time the form is reopened. How can I store those values - I tried a sub form with reference to a table that had two fields - [startdate] and [enddate] however, even though I removed the navigation buttons and displayed only one record somehow the user ended up with two records and this doubled all my values.

How should I store the dates without having to keep entering them and if the table is the solution how can I prevent more than one row being entered.

Thanks

 

[Hmadyson]

To do this, you will need to create a table that will store the 2 values. Then you will need to write code that when the form opens looks to see if there is any data and populates it, and then when it closes, it needs to save out the new values.

Please let me know if I can provide more assistance.