I have created a relational db in Access 2000.
My Order form has two subforms, Customer information and Order Detail information.
I would like to make the form read only when initially opened and then when I click a button make it editable or possible to "Edit Record" or "Add New Record."
I set the initially properties for the form AllowEdits to "NO"
I added a Button and in VB added Me.AllowEdits = True to the button.
It will allow me to edit information on the Form itself, but the subform of Order Details remains uneditable. The subform properties are set to "YES" for AllowEdits, AllowAdditions, and AllowDeletions.
If I use this button (called Allow Edits) or the Add New Record button (that I created), I may edit the information on the form itself, but not the subform.
Is it possible to do this, as I wish to be certain existing orders are not altered by accident, but I also want to add new orders or possibly edit existing ones.
Thanks very much.