Capture a value using parameter query

  • Thread starter Thread starter Amber
  • Start date Start date
A

Amber

I am using Access 2002. I have created a parameter query
that prompts the user for the data they would like to
search for.
How can I capture the value the user types in and have it
populate a field in my table?

Part 2: How do I search for / delete duplicate records in
a table before it is posted in a form? So, if one record
is listed twice, it will only show once in the form.

Thanks for the help!!!! Amber (e-mail address removed)
 
Dear Amber:

Part 1: Instead of using a parameter query, put the value of the
parameter into a textbox or other control and have the query use this
value instead of having a parameter. It will then be available for
other reference purposes after the query has run.

Part 2: It may be that you do not want to allow rows in a table that
duplicate a key consisting of one or more columns. In that case,
create a unique index.

Otherwise, it is hard to say what you are after. Please define a
"duplicate record". Is it the case where every field is identical
between two rows, or only certain selected fields are identical? And,
will the form be allowed to update this record, or does it just
display them?

If you mean for a form to update the records, and you display only one
of two "duplicated" rows, how are you wanting to determine which of
the two rows you want updated? Or do you intend updating both?

I am using Access 2002. I have created a parameter query
that prompts the user for the data they would like to
search for.
How can I capture the value the user types in and have it
populate a field in my table?

Part 2: How do I search for / delete duplicate records in
a table before it is posted in a form? So, if one record
is listed twice, it will only show once in the form.

Thanks for the help!!!! Amber (e-mail address removed)
Click to expand...

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top