Hello all,


I have a form named "Main_form" and in the form properties I have set the "Allow Edits" and "Allow Deletions" to no. I have a command button that calls a Macro named "MainForm_Macro.edit". In the macro I have tried to set the value "Allow Edits" to yes on the form. (Access 97)

In the macro I am using the Action "SetValue". In the Item area I have "[Forms]![Main_Form].[AllowEditing]" and in the Expression area I have "=Yes". I have also tried "=True" in the Expression area. I just can't figure this one out.

Any ideas on what I am doing wrong?

Thanks for the help,
Keith Bledsoe

Can't help with the Macro, but in code it's just
Forms!MyFormName.AllowEdits=True

Yep, I think you should use AllowEdits instead of AllowEditing.