Re: Editing Data in Form

Tech-Archive recommends: Fix windows errors by optimizing your registry

It always amazes me how questions run in cycles. I've read this same question
twice in the past 24 hours!

My guess is that you're doing something in code, probably in your Form_Open,
Form_Load or Form_Current event to assign a value to a control. When you do
this the current record then becomes editable.

Moving to another record will reset the locked state. If this is happening in
the Form_Open or Form_Load event, you can follow the assignment code with

DoCmd.GoToRecord , , acNext
DoCmd.GoToRecord , , acPrevious

and this will reset it. If it's in the Form_Current event you'll probably
need to rethink your design.

BTW, the same thing will happen if you open the form in ReadOnly mode.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

.

Quantcast