Command button to allow edits not working ??????

[TenOc]

I have a form which is primarily used is to add new records – not edit the records. Therefore, On the form properties I have AllowEdits = No.
However, there are times in which it is necessary to edit a record. Therefore, I have a button on the form which on click event should allow edits. The code is below

Private Sub cobEdit_Click()
     If MsgBox("If you change the name it will change all History.  Better to create a new account", vbYesNo, "1st Edit Confirmation") = vbYes Then
        If MsgBox("Are you SURE you want to EDIT?" & vbCrLf & _
            "I STRONGLY suggest a new account.", vbYesNo, "2nd EDIT Confirmation") = vbYes Then
     
   AllowEdits = True
      End If
        End If  


End Sub

After clicking a button I still cannot edit an item. What am I doing wrong?

[Welshgasman]

Prefix the property with Me. ?

[davegri]

Check this property:
If form property DATA ENTRY is Yes, then the form is restricted to entering new records only.

[Micron]

What's missing from the info is how the form is being opened. If the data mode is being set via code, this can over-ride form properties. You may have to tweak AllowAdditions, DataEntry and AllowEdits all at once when switching options. Another way might be to open the form as DataEntry at first, then switch the mode. While that doesn't determine if records can be edited (edits could be done via code), from a user standpoint it should appear that way because all they'll see is a blank record for adding.

Was that a manual attempt to wrap the code in code tags? Closing bracket is missing, so that should explain it.

[TenOc]

Prefix the property with Me. ?

Adding me. did not help

[TenOc]

Check this property:
If form property DATA ENTRY is Yes, then the form is restricted to entering new records only.

DataEntry is NO

[TenOc]

What's missing from the info is how the form is being opened. .

The form is open by a command Button on the "Start" form.


Also thanks for the ] hint

[Micron]

The form is open by a command Button on the "Start" form.

Well, that's a start, but it's only a wee morsel. I guess you should post the code that opens the form so we can see if you're using the DataMode parameter since you didn't address that.

If the data mode is being set via code...

[TenOc]

Well, that's a start, but it's only a wee morsel. I guess you should post the code that opens the form so we can see if you're using the DataMode parameter since you didn't address that.

See screen shot below

[davegri]

After clicking a button I still cannot edit an item. What am I doing wrong?

What exactly does this mean?

You can see records and when you try to change a value, you get a beep?
You cannot see any records at all?
You get some error message? If so, it would be helpful for us to know.
If error message, what exactly do you do that causes it?

[TenOc]

What exactly does this mean?

You can see records and when you try to change a value, you get a beep?
You cannot see any records at all?
You get some error message? If so, it would be helpful for us to know.
If error message, what exactly do you do that causes it?

I see all the records And all fields.
I do not get an error message
There is no beep
I cannot change any field in an existing record because no field will allow me to click on it that is I cannot have it get focus. I'm a newbie so excuse me if I did not describe this correctly.
I can add a new record, but once added (I move off the record so it is automatically saved) I cannot change any information in a field of the new record.

[davegri]

I see all the records And all fields.
I do not get an error message
There is no beep
I cannot change any field in an existing record because no field will allow me to click on it that is I cannot have it get focus. I'm a newbie so excuse me if I did not describe this correctly.
I can add a new record, but once added (I move off the record so it is automatically saved) I cannot change any information in a field of the new record.

Just to narrow it down, if in design mode you change the form property ALLOW EDITS = YES, can you now edit a record?
If not, then go back to design mode and look at a textbox property, Data tab. Is the textbox locked or disabled?

If not, then there appears to be code that you are not aware of that is restoring ALLOW EDITS = NO in one of your form events.

[Micron]

If the latest posts don't help, consider copying, compact/repair the copy, zip and post here for analysis. I see from the pic that you're using a macro; AFAIK, not setting this parameter in the macro allows the property sheet settings to take precedence so I suspect that's where the problem lies. I considered that there might be an underlying query for the form which is not updatable, but I don't think you can add records to such a query.

[TenOc]

I think I have found the problem

Form on Current Event. When I commented the "acNewRec" it works.

Private Sub Form_Current()
DoCmd.SetWarnings False
'DoCmd.GoToRecord , , acNewRec
End Sub

Now the question is how to have the NEW to be added record to have the focus when the form opens?????

[Welshgasman]

I think I have found the problem

Form on Current Event. When I commented the "acNewRec" it works.

Private Sub Form_Current()
DoCmd.SetWarnings False
'DoCmd.GoToRecord , , acNewRec
End Sub

Now the question is how to have the NEW to be added record to have the focus when the form opens?????

Put it in the form load event.?