Open one form with different queries

  • Thread starter Thread starter Sash
  • Start date Start date
S

Sash

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

run append query from form 3
Disable/Enable all controls on a form based on value of anothercontrol 2
Problem with Parameter Query from a Form 5
PLEASE HELP: Refresh a subform 5
Access Sub form opens before the main form in MS Access 0
Looking for New Approach 1
Refresh data in sub forms when one sub form is edited 4
opening form depending on value and passing another along. 8

Back
Top