Creating reports for a search form

[Grub via AccessMonster.com]

Hello, I have been givin a test project. It is an equipment database which
comprises of two switchboards.

I am relatively new at Access, and have completed a trainnig course, but
seems the deeper I get into it the more amazing it becomes, and overwhelmed I
get. Yes, I'm out for a pity vote!

The switchboards comprise of many queries and reports, but a new "Search
Form" has been added, one which makes many of these other reports seemingly
obsolete.

The search form creates a query upon selection of a Floor(floor of building)
and a piece of equipment(e.g. fax machine) and then you click a query button
and away it goes and brings up the matching query.

The main problem I have, is that I have been asked to create a report for
this "search form". This "search form" was designed by someone else who
isn't here any more. It comprises of a header, 2 "unbound" (drop down menu
of floors & equipment) selections, (one for Floor and one for equipment) and
the query button.

In the report I basically need the same basic results for all floor/equipment
correspondance. And it has several fields I need to display, e.g. location,
model, barcode, cartridges for use etc.

Not sure how to create a report for a different query each time or how to
link it into the whole structure. but be sure I will be working on it right
now stil, any help would be great, I'm learning alot from it at least.

I'm unsure if it goes as deep as me learning the coding part of access, or it
is much more simple than that.

Regards.
Grub.

 

[Allen Browne]

Your search form will either put a Filter on the form, or else it will
assign the RecordSource of the form. You can trace the code through whatever
button you use to execute the search.

If a filter, it will show the word "(Filtered)" in the horizontal scrollbar
area (immediately beside the navigation buttons, at the bottom of the form.)

If is is a filter, you can use the value of the form's Filter in the
WhereCondition of OpenReport so the report shows the same records as the
form.

If the form changes the RecordSource, it is probably easiest to generate the
WHERE clause of the statment at the same time, and then use it later in the
WhereCondition of OpenReport. The alternative is to save your report
unbound, and in its Open event, assign its RecordSource property to be the
same as the form's RecordSource.

Either way, you are going to need to handle some code to get this working
for you.