Error Message

[ddrew]

I get the following error message when I open a form, but I cant see anything wrong:

Run Time Error '2447':

There is an invalid use of the . (dot) or ! operator or invalid parenttheses.

This is the code that causes the problem:

Private Sub Form_Activate()
If Me.SumOfTotalGVS > 16 Then
MsgBox "You have exceded the total amount of GVS on the CATT site"
Let Me.SumOfTotalGVS.BackColor = 255
Me.SumOfTotalGVS.ForeColor = 65535
Else
Let Me.SumOfTotalGVS.BackColor = 16777215
Me.SumOfTotalGVS.ForeColor = 0
End If
End Sub

 

[KenHigg]

Not sure if I ever used a 'Let' statement like that...(??)

 

[ddrew]

OK I removed let, but i still get the same error

If Me.SumOfTotalGVS > 16 Then

MsgBox "You have exceded the total amount of GVS on the CATT site!,"
Me.SumOfTotalGVS.BackColor = 255
Me.SumOfTotalGVS.ForeColor = 65535

Else
Me.SumOfTotalGVS.BackColor = 16777215
Me.SumOfTotalGVS.ForeColor = 0
End If

 

[KenHigg]

Hum... I can't see anything else...

What line does it zonk on when you step through it?

 

[ddrew]

If Me.SumOfTotalGVS > 16 Then

 

[KenHigg]

And 'SumOfTotalGVS' is the name of a text box on the form?

 

[ddrew]

Yes thats correct!

 

[KenHigg]

Maybe:

If Val(Me!SumOfTotalGVS) > 16 Then


???

 

[Ron_dK]

Me.SumOfTotalGVS.BackColor = 255
Me.SumOfTotalGVS.ForeColor = 65535

Else
Me.SumOfTotalGVS.BackColor = 16777215
Me.SumOfTotalGVS.ForeColor = 0

In stead of me.Sum........ try :

Me!SumOfTotalGVS.BackColor = RGB(255,255, 255)

etc.

 

[ddrew]

I dont beleive that this is the problem. The code works fine. The only time this error appears is when I open the DB.

 

[KenHigg]

I think something else is causing it. Have you compiled the entire form code to see if it zonks in any other places? Can you cut out enough to post?

 

[ddrew]

Ive compiled the DB and it shows no errors. Not evan in that piece of code. The smallest I can get it is about 2mb. Im happy to PM it to you if you really want to look. Aside from that its going to take a lot of stripping out.

 

[KenHigg]

Can you do a new db, then import the form and table (with just a couple records then post that?

 

[red2002yzfr1]

What ever happen to this? Any success in eliminating the error?