Unable to lock non-string fields on a form

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

Guest

Hi, I was wondering if anyone could help. I have a strange problem on one of
the forms I have created. In the design view of the form, I selected all
fields and set them to be locked, then when the form opens, the first field
is unlocked and then the _AfterUpdate for that field unlocks the next, and so
on.

Now when the form opens, my first field is unlocked as required, however if
I then try and enter any data in a field defined as a string, I cant (this is
as it should be), my problem is, any fields setup for integers can have data
enetered even though they are locked.

If I manually put code in the Form_Current to Lock and unlock fields I get
the same problem - strings act as they should, but integers never lock.

Any help would be greatly appreciated
 
Hi Arvin,

Thanks for the quick reply, I have tired using the code you mentioned and I
have the same problem, fields for strings lock as they should, but fields for
integers dont. Any other ideas?
 
Hi Arvin,

I have solved the problem, it was user error (mine) I should have checked
my code more closly.

Sorry.
 
Back
Top