making a form & subform read / write

  • Thread starter Thread starter JulieD
  • Start date Start date
J

JulieD

Hi All

i have a form with a subform .. on opening the form is set to allow edits /
allow additions & allow deletions as NO ... however i've just added an EDIT
RECORD button that on press changes the allow edits / allow additons to YES
... works fine, however, i can't get the subform to behave.

The subform's allow edits / allow additions & allow deletions are set to YES
all the time .. but on open you can't add a record to the subform, so i'm
guess it inherits some of its behaviour from the main form ... but when i
change the main form's properties to yes the subform still won't allow
additions ... any ideas?

Cheers
JulieD
 
Hi Julie

The subform has its own AllowEdits properties etc:

Private Sub cmdAllow_Click()
Dim bAllow As Boolean

If Me.Dirty Then
Me.Dirty = False
End If

bAllow = Not Me.AllowEdits

Me.AllowEdits = True
Me.AllowDeletions = bAllow
Me.AllowAdditions = bAllow

With Me.frmInvoiceDetail.Form
.AllowEdits = bAllow
.AllowDeletions = bAllow
.AllowAdditions = bAllow
End With
End Sub
 
Hi Allen

thanks for this .. .i had actually tried it this way but was referring to
the subform by the wrong name (didn't create the database - just helping a
friend out on one for a charity ... you know the thing and didn't realise
that they had left spaces in their object names)

But thanks for the code it's a lot neater than how i was doing it.

Cheers
JulieD
 
Back
Top