Debug/Compile Database

[Stroud1977]

Hi, this is my first database, and with help from you helpful lot, I'm making good progress.
My database is seemingly working fine, but when I try to Debug/Compile Database in VBA menu I get the following error

'Compile Error, method or data member not found'

and it's higlighting the '.frmCalendarMain' bit (including the fullstop at the start)

in this piece of code.

Private Sub Form_AfterUpdate()
Me.frmCalendarMain.Form.Requery
End Sub

Now, the help menu says this happens when links or titles are misspelt etc, but 'frmCalendarMain' seems fine and can be opened without problem and the database itself seems to work fine.

Should I be concerned with this error? (I'll attach a copy of the DB if you want to take a look)

Many thanks, Steve

 

[pr2-eugin]

You have more than that problem !

Here is the link on how to refer to SubForms : Refer to Form and Subform properties and controls
Here is a link on Proper naming convention : MS Access Naming Conventions

 

[Stroud1977]

Thank you for taking the time to reply and thank you for the links, I'm sure they will be very helpful to me.

Are you saying that it's coming up as an error because frmCalendarMain has been named or linked to incorrectly?
I'm a newbie so excuse the questions, but this is confusing to me because apart from the VBA compile error, in use the calendar subform works and links as it should.

Most of the code concerning the calender was taken from a calendar database template some kind soul put out on the internet.

 

[pr2-eugin]

It is always best if you use ! (Bang) operator over . (dot), specially when dealing with Subforms. I did not go into the details, because (no offense) but all your forms were opening with no close option, so I have to go and right click to close. So I stopped after trying to figure out what form belongs to what or which form I am looking at.