G
Guest
Greetings.
I'm currently building a bibliographic database system for our company. This
system requires several user-friendly "criteria" forms.
What I specifically want to do is construct a main form with a subform. The
upper part of the main form will have criteria fields and a search button.
When the user presses the search button, all the criteria entered are used to
query the data. The results of the search will appear as a list of records in
the subform. The subform will appear as a datasheet. I can build the main and
subforms quite easily. Where I stumble is in setting up the criteria fields
in the main form and linking them to a query.
I welcome any help or suggestions in getting this criteria form to work.
Note: I posted this message earlier this morning in response to Alasdair
(Re: Database Search Facility). Please accept my apology for duplicating the
message.
Dirk Schmid M.Sc.
Data Analyst, Environmental Microbiologist
North/South Consultants Inc.
Winnipeg, Canada
I'm currently building a bibliographic database system for our company. This
system requires several user-friendly "criteria" forms.
What I specifically want to do is construct a main form with a subform. The
upper part of the main form will have criteria fields and a search button.
When the user presses the search button, all the criteria entered are used to
query the data. The results of the search will appear as a list of records in
the subform. The subform will appear as a datasheet. I can build the main and
subforms quite easily. Where I stumble is in setting up the criteria fields
in the main form and linking them to a query.
I welcome any help or suggestions in getting this criteria form to work.
Note: I posted this message earlier this morning in response to Alasdair
(Re: Database Search Facility). Please accept my apology for duplicating the
message.
Dirk Schmid M.Sc.
Data Analyst, Environmental Microbiologist
North/South Consultants Inc.
Winnipeg, Canada