Prev: simple can't find form question
Next: Form Security
From: Sash on 24 Mar 2010 15:37
Is it possible to open one form using a different query depending on what
button the user selects. For example:

Sort High/Low
Sort Old/New
Search MRN
Search Account#
Search SSN

I should also mention that this form has a subform.
From: Sash on 24 Mar 2010 16:13
Got it. Below is what I put behind a button on the form for Sort High/Low and
it filters using a query.

Dim stHighLow As String
stHighLow = "SortHighLow"
DoCmd.ApplyFilter stHighLow



"Sash" wrote:

> Is it possible to open one form using a different query depending on what
> button the user selects. For example:
>
> Sort High/Low
> Sort Old/New
> Search MRN
> Search Account#
> Search SSN
>
> I should also mention that this form has a subform.
 | 
Pages: 1
Prev: simple can't find form question
Next: Form Security