Using a form to seach a database...

[Guest]

This is a complicated (for me anyhow) issue.

I'm trying to use a form to search for multiple fields from a a few tables.
Its an inventory database - here are my fields:

The user chooses a location from a drop down box - there are four locations.
I want the database to then filter the inventory in that specific location -
before I even start an inventory search.

There are two search paramaters (its a book DB) - Book Name and Book author.
There is also a drop down box w/a list of the type of book being looked for
(sifi for science fiction, comp for computers etc.) Then the user clicks the
search button and the information comes up on the right side of the form in a
bound object frame (I assume that a subform needs to be made which will show
up here.)

I was working on this for a few hours last night. The location drop down
was simple enough and the book type drop down was simple (used SQL to create
a distinct type query.) The rest has been designed - it just needs to be
bound in order for everything to work.

I realize that this is a complex question - If there is a website that
offers examples or templates of Access inventory inquery forms feel free to
link me there.

Thanks!

 

[SusanV]

Hi Dan,

This web site should help:
http://www.mvps.org/access/forms/frm0045.htm

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), are several small Access
database samples that might help. They're not inventory samples, but they
show how to programmatically create queries based on information in a form.
You could use this to set the RecordSource for your subform. Take a look at
these:

CreateQueries2.mdb
CreateQueries4.mdb
CreateQueries5.mdb

Especially look at Form7 in CreateQueries2.mdb

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thank you Susan and Roger. Both responses were extremely helpful!