Option buttons are the circles that you click on, which puts a dot
inside the circle. This method, which is just the way that I would go
about it, would require some VBA programming. If you're not altogether
comfortable with that, you could do what was suggested to you before.
One command button for each type of query (one query for subject, one
query for keyword, etc.)
Before you try that, I believe you said you were on Access 2000. If so,
this will be helpful for you to download/use/etc:
<
http://msdn.microsoft.com/library/de...y/en-us/bapp20
00/html/mdbdownload.asp>
(make sure you get everything between the <> marks, that's the whole
address.)
That is the link to Microsoft's downloadable version of the Developer
Solutions database (Solutions09.mdb). There are instructions in that
database on how to do this. It's under "Using queries with forms and
reports" and then under "Use a custom function in a subform's SELECT
statement" (change the dates to sometime in 1996 to see data). This is
a good tool, I use it myself from time to time.
You could also look here: <
http://intranet.mathtechinc.com/doc/bldapps/
and scroll down to "Filtering and Sorting Data in Forms and Reports" in
the window on the left side. This site says it's for Access 97, but it
mostly applies to A2K as well.
Use your help file, the internet, newsgroups, etc. Here's a few of my
favorite sites (I've been doing this for a few years now but still
sometimes consider myself somewhat of a "newbie", so I hope these help
you like they've helped me)
A good place to search for the answer to a question. See if someone has
asked the same question you're having, sort of like DevelopersDex
(questions you post here, will also appear in DevelopersDex):
<
http://groups.google.com/groups?hl=e....databases.ms-
access>
Wonderful VBA reference:
<http://www.netcoders.dk/docs/vbscript/vbstoc.htm>
A great site with great samples:
<http://www.mvps.org/access/>
*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!