choosing between queries when opening form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: scottyboyb <scottyboyb@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Sat, 10 Jan 2009 15:10:03 -0800

Greetings,

I have two queries. Both based on the same two tables. One query gives me a
list of current members only and one gives a list of past members only. I
would like to have a form that asks me what query to use when it opens. Is
this possible?

Many thanks.
Best,
Scott
.

Follow-Ups:
- RE: choosing between queries when opening form
  - From: scottyboyb
- Re: choosing between queries when opening form
  - From: John W . Vinson

Prev by Date: Re: How make subform independent of main form?
Next by Date: Re: How make subform independent of main form?
Previous by thread: How make subform independent of main form?
Next by thread: Re: choosing between queries when opening form
Index(es):
- Date
- Thread

Relevant Pages

Re: Username and Usergroup
... > group that has the permissions to run the query in question, ... who opens which forms. ... "Approved" field) and another one for members of the "Supervisors" group ... queries that are nearly identical, one for each group, a single query can be ...
(microsoft.public.access.formscoding)
Re: Inconsistent MDX query performance
... Interestingly as I broke my query down bit by bit (basically I chopped the ... all of the RAM and brought the server down. ... Fortunately because my queries are generated programmatically it is fairly ... that have extreme numbers of members along one or more dimensions. ...
(microsoft.public.sqlserver.olap)
Re: Membership database updates
... When you open any Query in Design View, click on the toolbar just next to ... black down-arrow where you can change your query to an Append or Update ... If you have any current members in your Import list, ... You mention Update Queries and Append Queries but I can't find how to ...
(microsoft.public.access.tablesdbdesign)
Re: Syntax needed to get needed reports
... what you posted as a query will not work for you because you must ... I ran the update query below to see what happens. ... > UPDATE Members ... > WHERE [Hobbies] Is Not Null; ...
(microsoft.public.access.gettingstarted)
Re: Membership database updates
... Add both your Current Table and your Imported table into the query grid. ... That gives you a list of all the members whose addresses are different in ... this can be done more quickly using a macro to run the queries ... You mention Update Queries and Append Queries but I can't find how to ...
(microsoft.public.access.tablesdbdesign)