Hi John,
You can use the built-in "Filter by selection" and "Filter by form" options,
but this just filters the recordset, so that you still have to use the
navigation buttons to move through the selected records. Frankly, I don't
think these built-in options are too useful.
Are you familiar with working with VBA code and SQL (structured query
language)? You can create an unbound form, with controls such as combo boxes,
list boxes, text boxes, check boxes, etc. You can then write VBA code to
create the WHERE portion of a SQL query on-the-fly, and then set the
recordsource for a subform equal to your completed query. This technique is
demonstrated in Scott Barker's Access Power Programming books (Chapter 8 for
the Access 2000 version of this book). It is a very common technique, so
you'll likely find it discussed in any number of Access books geared towards
developers. Look for the topic "Query by form" in the table of contents of
various Access related books at your favorite bookstore.
If you send me a private e-mail message, I will send you the example from
Access 2000 Power Programming.
Tom
Xaos168YYY@Dcomcast . Jnet (<---Remove capitolized letters and spaces)
Please do not post your e-mail address unless you obscure it as I have done.
_______________________________________
:
i want to create a form through which it will search thru a set of records
and display the results on a form and not a table!
how would i go bout doing this??
thnx in adv
