Run Command

[techkenny1]

Hi all,

On a text box I have on the click event this code:
'DoCmd.RunCommand acCmdFind'
While it will search and find a record, when I go to change data on the form, and then go to do a search again it comes up with this error;
"you can't use Find or replace now"
So I have to close it down and then click on the field to do a search again.
Is there a reason for this error?

 

[SeeThru]

It's exactly as if you had clicked the find button. some things to check

Are you in a field with validation, and the validation is failing?
Does the entire record have validation (afterupdate, ect) that is preventing you moving off the record

If you get a message when you move off the record you are on, you need to resolve this before the search.

SeeThru
Synergy Connections Ltd - Telemarketing Services

 

[kjv1611]

techkenny1,

Not sure if it will resolve your issue for sure, but why not just use a Command Button if you've got to click it to search anyhow? In a way, that might help, but without more detail, it's difficult to know what all is going on...

--

"If to err is human, then I must be some kind of human!" -Me