Search Feature

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I know this is already problematic...... but,
I am trying to tweak an existing DB developed by another user (here, fix
it). They used a Search Button code from "Graham Thorpe." Works great for
searching the subform for an existing record and giving the user three
different prompts when the record exists, does not exist or errors.

Where I need help, when the search returns "Record does not exist," and the
focus returns to the search box, the form/subform gets focus on the frist
record of the database when I want it to remain with no focus! Any advise
on how to only get focus when a record is found? I can post the code behind
the search button! Maybe start over with a different type of search? but
being fairly new to Access development I would need help with starting over.

Thanks, Rohn


.

Quantcast