Allow Form Editing (1 Viewer)

[Tim Bedborough]

Hi all. Just getting into coding but been using Access for a while. Could use some help on allowing editing please.

I have a form which I've locked 'OnCurrent' using :
Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowAdditions = True
I then have btnedit button to change things to editable.

I have a new record wizard which opens the form but I want to allow editing at this point without the need to click the edit button.

I am opening this form from another using :
Private Sub btnopenfrmjobs_Click()
DoCmd.Close acForm, "frmnewjobwizard1"
DoCmd.OpenForm "frmjobs"
DoCmd.RunCommand acCmdRecordsGoToLast
DoCmd.GoToControl "RPRManager"
End Sub

at this point I put Me.AllowEdits=True but it doesn't like it. Do I need to specifically name the form somehow ?

Thanks,

 

[bob fitz]

Perhaps:

Private Sub btnopenfrmjobs_Click()
DoCmd.Close acForm, "frmnewjobwizard1"
DoCmd.OpenForm "frmjobs"
Forms!frmjobs.AllowEdits = True
DoCmd.RunCommand acCmdRecordsGoToLast
DoCmd.GoToControl "RPRManager"
End Sub

 

[Tim Bedborough]

Thanks Bob. I was close but couldn't get the right bits in the right place. This worked a treat. Very much appreciated and thanks for quick response.