I usually have a tblGlobal (Global table) where I keep global fields to store information temporarily for use by scripts.
You can script the find function and activate it with a "Data Range Search" button. The Find Script uses a Custom Dialog box
In general terms have the script do the following:
- Clear the globals (Set Fields = "")
- Use the Custom Dialog box step to get the inputted dates. You can provide instruction text and then on the "Input Fields" tab have input one go to the starting date and input field two go to the ending date.
- Error trap the entries. By that I mean that neither date is blank and that the start date is less than the ending date. For each test (using an "IF" test) if true open a custom dialog to inform the user of the error and then "Exit Script"
- If their are no errors you can then enter Find Mode and use the globals to set the range you need in the find.
Thank you Mark & Phil for your suggestions. I will try these ideas and I'm sure both will be great, thanks again