AAH! Help! My form stopped allowing any editing at ALL

[zestygirl]

Have no idea what happened.

I have a form. Assigned a little code to lock certain fields on certain criteria.

The form stopped allowing any and all edits.

Don't understand how the code locked the entire form, it was very specific to just certain fields but, nonetheless, I deleted it all.

Took out the source info.

Still cannot edit a single field, bound or not....

Is there a way I can copy just the design of the form to re-do?

Or - is there anything you can think of that might have corrupted my permission to edit?

 

[PNGBill]

If you lock one control on a form it shouldn't stop some other control being changed but, all you need to do is add a button that has code to unlock - reverse the earlier changes made.

The setup you used, keep this.

Create a Command Button and use caption "Allow Edit" eg.

If you followed my code earlier, then use this code in the on click event of the commend button.

Me!BankID.Locked = False   'Unlock BankID Control
    Me!StatementDate.Locked = False   'Unlock StatementDate Control

I locked two controls and are now unlocking them to allow edits.

 

[PNGBill]

Do you have a backup database?

Go to File, Get external data and select just the form in question. watch for subforms as well.

This will allow you to import the Form. Only importing a table will get data. The form is just a "template" for want of a better word.

Delete the original form and rename the imported form and you should be back in business.

Start the code work one task at a time and check the form to see if it works how you want and then report what action caused the problem, if indeed it is related to the two controls you locked.

Locking the controls will prevent new data entry.

to add records, you need to include the unlock code in your "Add Record" button.

 

[boblarson]

Or next time upload a copy here and we'll help you figure out why it is locked.