Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How do I use a field value as search criteria?

How do I use a field value as search criteria?

How do I use a field value as search criteria?

How do I create a find that uses the value entered in a field as search criteria?

The first field in my database is to be a blank search field. When the user scans a barcode, the value is entered into this field. (Got that much, at least.) When they click the button below this field labeled SEARCH, the record whose ID number matches the value in this field needs to pop up. Easy, right? Not for me, I guess.

I have tried several things on my own, but to no avail. I'm sure this is something so impossibly simple, it ought to be funny. I'm a beginner at this, what can I say? I give you permission to laugh if you want, but while you're getting your kicks, please tell me what I can do to make my database desires a reality.

RE: How do I use a field value as search criteria?

All you need to do is go into FIND mode before you scan the barcode into the ID Number field, then press ENTER.

But if you want to use a field and button, you need to define the field for scanning as a variable type field. Lets call it VarID.
* Put this field on the form and enter a valid ID into it.
* Do a manual FIND and enter =@VarID into the ID Number field. Click OK.
* Now on the Action Bar it will say "current find/sort" and you can type over that with a name to refer to your just completed FIND.
* In your macro attached to the search button, you use the FIND you created above.

Sue Sloan

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close