Referencing a Subform Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MinnieTheMinxCat - 29 May 2008 09:08 GMT

I am very confused - am working with Access 2007.

Yesterday - I created form with 2 levels of nested subform - and referenced
the controls on both from the top level, and it worked fine. Code extract as
follows:

Private Sub SelectStaff_Change()
Me.Grade_Label.Visible = True
Me.Grade.Visible = True
Me.sfrmTimesheetdate.Form![Date].Enabled = False
Me.sfrmTimesheetdate.Form!sfrmTimesheet.Form![Task ID].Enabled = False
End Sub

The only thing I did after testing this - was to add an additional field to
the sfrmTimesheet form, but now this doesn't work. I'm sure adding the field
can't have had anything to do with the error - but can't imagine why Access
suddenly has changed its mind about this code.

The error is occuring on the final line of the above extract and says "Run
time error '2136500594 (800f00e)' Method 'Form' of object '_subform' failed.

HELP Please!!!!!
Thanks
Lindsay
(Minnie the Minx Cat - is asleep by the side of me and couldn't give a toss!)

Reply to this Message

Paolo - 29 May 2008 09:46 GMT

Hi Lindsay,

the "Method 'Form' of Object '_Subform' failed" error can be caused by a
corrupt subform.

To resolve:
You can try to compact and repair database

or

create a new form
copy all the controls of the subform in the newly created form (and the code)
name the old subform in another way and name the new form as the old subform

HTH Paolo

> I am very confused - am working with Access 2007.
>
[quoted text clipped - 21 lines]
> Lindsay
> (Minnie the Minx Cat - is asleep by the side of me and couldn't give a toss!)

Reply to this Message