Parameter Query

  • Thread starter Thread starter JoeCL
  • Start date Start date
J

JoeCL

Hello!

I need to create a macro that displays a message like 'No
Record Found. Please re-enter' when no record is found in
the database using a parameter query. Ex. [Enter Last
Name] and no record is found. Thanks
 
Dear Joe:

I'm going to suggest a completely different approach that I believe
will solve your problem in a different manner.

If you put all the last names that DO return results into a combo box
on some form, then the query can reference that combo box instead of
having the use mistype the name and turn up empty handed. No matter
what selection is made in the combo box, given a query for the combo
box's row source that guaranteed results, there will be something
returned by the query.

I believe this is a better interface for both the programmer and for
the user. Try it, I think you'll like it.

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