Find with Expression Builder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't know VBA, please tell me how to do this with Expression Builder!!!

I have the following field:
Loan_Number

What I want to happen is that the user opens up the form. They type in
their loan number, lets say it's 12345. They click on a pair of binoculars
next to the loan number and a pop-up box or message box will appear telling
them that it's unable to find that loan number (because it doesn't exist)
OR,
when they hit the binoculars it just takes them to loan number 12345 because
it turns out it's already in our database.
Can someone tell me EXACTLY how to do this?

My field name is Loan_Number, the name of my form is QC_Audit and the
name
of the database is QC_Tracker.

I literally need step-by-step instructions. Rick, if you read this,
you
tried to help me previously but then I was out for a while and now I'm
getting back at it.
Thanks to anyone who can help!!!!
 
Put the form in design mode. Add a button to the form and, when the button
wizard appears, select

"Record Navigation" and "Find Record"
 
I tried this but I don't know how to connect the binocular button created by
the form wizard, to the Loan_Number field? I can create the command button
as you stated here by using the wizard, but how do I connect it to the field
so that when a loan number is input, it looks up THAT field?
 
Back
Top