applyfilter issues.

[Jimmy]

Probablly a simple answer but I'm not sure where to begin. I have one
customer form that can be opened two ways. One of the fields in the customer
table is ActiveCustomer. If users open the form from a main menu I want the
form to open but only contain records where ActiveCustomer = Yes, i.e.

OnOpen is DoCmd.ApplyFilter , "ActiveCustomer = Yes"

If however, the user is on another form where they are viewing records
pertaining to a certain customer, there is a command button that will allow
them to open that same form and go to a specific record. This WAS done with

DoCmd.OpenForm "frmContacts", , , "ClientID = " & Me!ClientID

The problem with my method is, that the user can click on the above button
but as soon as the form is opened, it applys the filter defined in the
onopen event of the form.

How should I set up the forms so that both items work correctly?

[Rich P]

You can use the OpenArgs property to pass a variable to the open/load
event of the form which would specify either to use the form filter or
not. There is a real good example in the help files under openargs.

Rich

*** Sent via Developersdex http://www.developersdex.com ***