Validation issues

[DahMurf]

Here's my scenario:
User opens form.
First field is Vehicle. They MUST key a vehicle number before doing anything else.

I have code in the BeforeUpdate of the Vehicle field. It works fine. The user cannot leave
The field without entering a valid value.

I have the same code in the LostFocus of the Vehicle field. I did this in case they tab past the field without entering a value.

In both sets of code I set focus to a different field and then back to the vehicle field. This puts the focus back to the vehicle if they have tabbed or moved elsewhere.

I am sometimes getting the following message when tabbing out of the field:
Run-Time error ‘2108’:
You must save the field before you execute the GoToControl action,
The GoToControl method, or the SetFocus method.

Question #1: Is there some kind of test I should do to determine if I should execute the SetFocus command?

Question #2: You may have guessed, the code works great except that I can not leave the form. So if I’ve opened the form by accident I can’t cancel and close without entering a valid vehicle number. I have a cancel button but the field validation happens first, which gets me stuck in the field. Any suggestions?

 

[randy700]

How about setting the Locked property to YES or the Enabled property to NO on all fields you don't want the user to be able to access. Then, in the AfterUpdate event of the vehicle field you can change the Locked/Enabled property.


Randy

 

[DahMurf]

Thanks for the response. I tried it but I've found that I can't change the locked or enabled property on all the fields. Not sure why.

 

[randy700]

What kind of control prevents you from changing the locked and enabled properties?

Randy

 

[DahMurf]

We got to a final resolution in this thread. Two answers, one in the middle and one at the bottom of the thread.

http://www.tek-tips.com/viewthread.cfm?qid=941073&page=1