I have a form that shows all my records from a table. I am trying to create a macro that allows me to quickly show transactions between a start and end date when I click a button. This is not for a report, just quick viewing.
(This is a trial database, spaces in field names and such will be removed on actual build.)
Right now I have an ApplyFilter action with the following arguments:
Code:
[Transaction Date] Between [StartDateComboBox] And [EndDateComboBox]
Transaction Date = date each record was entered in table, stored value.
StartDateComboBox = Unbound date field in my footer.
EndDateComboBox = Unbound date field in my footer.
When I run the macro I am prompted (alert style box) to enter the values for both unbound text fields, even when I enter them in the footer BEFORE I run the macro. When I enter them manually in the prompts the macro runs properly, but my question is this:
Is there something I am missing in my arguments that would prevent the macro from using the current values in these unbound fields? Can I add something that makes it pull and use the values automatically, without prompting me? For example:
[StartDateComboBox].CurrentValue
Or something similar?
If it helps the macro runs when I click a button that says "Show Range" to the right of the unbound date fields, it doesn't run automatically.
Sorry if my terminology is off, I'm very new...
Any help would be greatly appreciated!
Thanks.