I have built an Access Database and have used the wizard to help me create some of the Command Buttons as many of them move from record to record and open forms with specific filters applied to them to apply criteria to certain forms.
I have also written some macro modules within the database to close down forms when new ones open to keep one form open at any one time.
I would like to know whether or not it is possible to close down a form whilst applying a specific filter to the opening form and if so, how one goes about applying this section of VBA.
Any help would be appreciated.
Thanks In Advance