Enabling and Disabling edditing

[Perfac]

I want to keep the form sort of read only, but when I try to add a new record via access command buttons
When I click on the Add Record command button
Then I get the message that "you can't go to the specified record"


currently using recordset type : Snapshot

The end result I'm looking for is locking editing in the Detail section and allowing editing and command buttons within the header or footer

[ranman256]

to edit, recset type must be dynaset
set form properties:
allow edits = false

then put an edit button in header, to turn on edits:
me.allowEdits = true

[Minty]

Just to clarify - A snapshot recordset is not updateable.
It's a read only snapshot of your data at the time the recordset is opened.

[Perfac]

"Allow Edits = False" Causes the text fields and combo boxes within the header/Footer to be unable for editing and I'm looking for a way to separate the way the form is locked
I want only the Detail Section to be read only and in the header/Footer I want to be able to use combo boxes and text fields.

[June7]

You NEVER want user to edit or add record directly in the Detail section? Set each control as Locked Yes and TabStop No.

Or perhaps use a Split form.

[ranman256]

then you must lock individ fields.