Filter by Form - Create button

[Guest]

How can I create a button that will open a form in "filter by form" mode? I
see this button in the upper tool bar, but would like to add it to my form.
Thanks, |JG

 

[Rick Brandt]

How can I create a button that will open a form in "filter by form"
mode? I see this button in the upper tool bar, but would like to add
it to my form. Thanks, |JG

Drop a button on your form and in its Click event have code...

DoCmd.RunCommand acCmdFilterByForm

 

[Guest]

Hi - I have a question along the same lines. I need to make a form where
users can select certain data; for example. They need to be able to pull
records that were opened (or closed) between two specific dates. Can you
please tell me how to do this?
Thanks,
Tammy

 

[Guest]

They need to be able to pull records that were opened (or closed)...
I'm assuming this data is kept in the record.

if you have someone enter the beginning and ending dates in two unbound
fields on the form, then you can have a button which builds an SQL WHERE
statement (without the WHERE) using the date info. Then do the following
me.Filter = strQuery
me.FilterOn = True

Hope this helps
James