Method Or Data Member Not Found Error

Moonshine

Registered User.
Local time
Today, 17:40
Joined
Jan 29, 2003
Messages
125
Hi all, i put this in the forms Forum, but it also is a VB error as well i guess...

I have a form in my database, its called "frm MainAmend", it bascially lets you amend a form from the database, that has already been entered.

On there there is many a option group, check box and text boxes... there are three check boxes in a group (not an option group) called Check246, Check248 and Check250

Anyway, when you click the "Amend" button, it does some basic validations, the one it falls over on is:

ElseIf (Me.Check246 = True Or Me.Check248 = True) And Me.ReferralDate_Combo.Visible = True _
And IsNull(Me.ReferralDate_Combo) Then
MsgBox "Please Enter A Date Of Referral", , "Core Assessment Forms v2.0"
Me.ReferralDate_Combo.SetFocus

It gives me the error "Method Or Data Member Not Found" on Me.Check248...

The check box is there, as it lets you select it using the Me. i have tried removing the Check box, adding one back in and renaming it. I have renamed the check box, and changed all references to the new name, still nothing....

It also does the same error on another field, but its the same problem and i have tried the same thigns with the same error happening.
 
It's to do with the bracketing, I don't remember the exact way but it's something like
ElseIf ((Me.Check246 = True) Or (Me.Check248 = True))
or try
ElseIf (Me.Check246 = True) Or (Me.Check248 = True)
 

Users who are viewing this thread

Back
Top Bottom