Connecting Tech Pros Worldwide Forums | Help | Site Map

Applying a filter in macro

Member
 
Join Date: Mar 2008
Posts: 41
#1: Mar 28 '08
I created a macro command button on my form. When pushed it gives me only the records of that person. I want to add a filter to this macro command button to limit those records to present day. How do you do this.

David

Minion's Avatar
Expert
 
Join Date: Dec 2007
Posts: 98
#2: Mar 28 '08

re: Applying a filter in macro


Quote:

Originally Posted by David Davis

I created a macro command button on my form. When pushed it gives me only the records of that person. I want to add a filter to this macro command button to limit those records to present day. How do you do this.

David

As we don't know what you're macro is currently it makes it hard to assist you. If you were to post your macro or convert it to VBA then post it we should be able to assist you.

- Minion -
Member
 
Join Date: Mar 2008
Posts: 41
#3: Mar 28 '08

re: Applying a filter in macro


Quote:

Originally Posted by Minion

As we don't know what you're macro is currently it makes it hard to assist you. If you were to post your macro or convert it to VBA then post it we should be able to assist you.

- Minion -

Minion,

I have a action: open report
Filtering: A individual's name
With a where condition of: [Instructor]=[Forms]![Christine]![Instructor]

I want to also filter by present date input as well. How do I add that to this macro.

David
Reply


Similar Microsoft Access / VBA bytes