I am using Microsoft Access 2010 and VBA
I want to create a form that acts on "MyTable".
I know how to create a query to restrict the view on "MyTable" by using "Between" as criteria on the [Date Of Data Entry] field (using the wizard thingy).
By default, I would like this form to load up showing all the records in "MyTable", (and I have locked it all down). If the user wishes to edit the records, then I would like to demand "between date" criteria.
I would like to create a Command Button in VBA to ask for a new "Start Date" & "End Date" and then have the form refresh to display the table with this new criteria.
Thank you for your help