Simple question regarding forms in Access

  • Thread starter Thread starter Mike H
  • Start date Start date
M

Mike H

Hello everyone,

First, I want to thank you all for helping all of us that post
questions. Second, I have a quick question that's probably really
easy to do:

I have a table full of wonderful data and I have a form with a drop
down that lists all the records in one field, "Suppliers". All I
want it to do is, when you choose a Supplier and click the "retrieve
records" button, all the records that contain that supplier open up in
a new window, ideally, formatted as a report rather than looking like
a query (it doesn't have to be updatable by the user).

And I'd love to have a second button that displays all of the records
in a nicely looking report format.

I tried using the report wizard to create this, but it made it look
nothing like I wanted it too...also, I felt like I needed to use a
form to make the GUI for this DB and then, ideally, have the output be
formatted like a report.

I appreciate any and all advice!

Thanks,
Mike
 
I have a table full of wonderful data and I have a form
with a drop down that lists all the records in one
field, "Suppliers". All I want it to do is, when you
choose a Supplier and click the "retrieve records" button,
all the records that contain that supplier open up in
a new window, ideally, formatted as a report rather than
looking like a query (it doesn't have to be updatable by
the user).

Create a query-based report that displays the data in the
format you'd like. In the Criteria row of the Suppliers
key field, enter:

=Forms!yourformname!yourcomboboxname

When the query is executed, only those records that match
the Supplier value the user has entered on the form.

Save your query, and open up your form in Design view.
Use the command button wizard to place a command button
that opens your report in Preview mode.

HTH
Kevin Sprinkel
Becker & Frondorf
 
Back
Top