Using a form to select query parameters

[Kate]

I have a database that has several update queries that are used to update
price information. Additionally, I have a macro built that runs the update
query (that prompts the user for the PO# and price it wants to update) and
emails the changes to an e-mail address.

Here's the trouble - often times, a user will update 5 - 10 prices and,
therefore, would have to run the macro 5 - 10 times creating extra work.

I would like to create a form (which I have already built with the
attributes I need) and would like for the user to be able to enter specific
criteria (PO#s) and be able to select multiple PO#s. Is there a way to create
a "add" field (like you do when using wizards - you select which fields you
want and click the arrow to add them to a "hold" field until you press next).
Then the query would be run using the PO#s selected and all records with that
PO would be included in the report the macro generates and emails?

Hopefully I have given enough detail as to what I'm trying to do. Thanks in
advance for any help you can offer!

Kate

 

[[MVP] S.Clark]

Since you have multiple selections, here's what I would do.

Make the Selection Tool a subform, based on a table.

In the query for the report, link that selection table to your main data
table, such that only those records are extracted.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[Kate]

Okay, I created a form that includes a list box (that is linked to a table)
that lists all PO#s available. I also created a text box that I would like to
be able to act as a filter. For example, the user may type in a MMYY
combination and, based on what they enter, the PO#s list box would filter
based on POs that only contain that MMYY combo. I have used the after update
function before, but am not sure how to, if you even can, use it to filter
based on part of a entry.

Ideas?