Opening a form according to a criteria

[prmitchell]

I wish to open a form by using a button (from a switchboard if you like)
where the records displayed match a criteria
eg. Clients.Status = true

and I also want to the able to open the same form - using a dikfferent button
where all the records are displayed, eg. All client records

so I wish to use different buttons, without having to make two separate forms which I know how to do

thank you in anticipation

 

[pbaldy]

This type of thing:

http://www.baldyweb.com/wherecondition.htm

You can hard code the criteria if you want.

 

[prmitchell]

This one has been solved