I have a form linked to a table, What I'm attempting to do is open the form and filter the data. At present I have the form set up so that the On Activate function calls a macro with unbound boxes that merely asks for the month, and year for which you are going to manipulate data. This macro assigns the month to one variable and the year to another variable and uses these values to filter the data.
Unfortunately the filter option seems to be running before the macro, (this only happens when I first open the db, not after the macro has been run one time). Since the On Activate runs the macro, I don't know how I can can use the VB code to tell it to run the macro, then use the results to filter the database. The filtering seems to work fine after the very first time I run the macro, but that initial time bugs me a little, making me wonder if commands aren't running in the order in which I want them to run. (Ie: Gather month data for the filter, then apply filter, then display form with the filtered data) Anybody have any suggestions about how I can structure this?
Kyle B
Unfortunately the filter option seems to be running before the macro, (this only happens when I first open the db, not after the macro has been run one time). Since the On Activate runs the macro, I don't know how I can can use the VB code to tell it to run the macro, then use the results to filter the database. The filtering seems to work fine after the very first time I run the macro, but that initial time bugs me a little, making me wonder if commands aren't running in the order in which I want them to run. (Ie: Gather month data for the filter, then apply filter, then display form with the filtered data) Anybody have any suggestions about how I can structure this?
Kyle B
