Using a query to display results in a subform.

[Guest]

Hello,

I am creating a databse for a small library. I want to create a form where
the users of my database can search by either "document ID" number or by
"Document Title" utilising wildcard searches in combo boxes. I then want the
results of the document they query by to display in a subform.

I have no idea how to do this so any help would be greatly appreciated!

Thank you

 

[Guest]

Best Advice...

What you are asking is for someone to teach you database design. You need
to spend some time with your application books at a minimum before you launch
into attempting to design a database.

 

[Guest]

Here's something for you, try looking at the Northwind sample DB which should
be packed along with your Office software. You'll find it under the Programs
directory. There you should see some good examples of how to write and use a
query based on a form's criteria.