Re: there is an invalid use of the . (dot) or ! operator or invalid parentheses

From: jac (anonymous_at_discussions.microsoft.com)
Date: 02/28/04 

Date: Sat, 28 Feb 2004 06:23:17 -0800

>-----Original Message-----
>On Fri, 27 Feb 2004 10:16:28 -0800, "jac"
><anonymous@discussions.microsoft.com> wrote:
>
>>curOrderSubTotal is a VBA variable declared as currency.
>>txtOrderSubTotal is a textbox on the form.
>>I have tried curOrderSubTotal = Nz(Me.txtOrderSubTotal,
0)
>>but I still get the same error. There is a lot of code
on
>>this command button.
>>Is it possible that the control is corupt?
>
>That, or the . ! error lies somewhere else in your code.
If you
>Compile the project does it compile OK? or does it
highlight this line
>of code? Why do you feel that this line is at fault?
>
> John W. Vinson[MVP]
> Come for live chats every Tuesday and Thursday
>http://go.compuserve.com/msdevapps?loc=us&access=public
>.
>I think this is line is at fault because when I single
step thru the code, it goes from this line to the On
Error GoTo Err_cmdAddRecord_Click code.
Another thing that is going is that when I change the
textbox (Me.txtOrderSubTotal) controlsource to nothing it
works fine. But if I set the controlsource to =Forms!
frmOrderEntry!ctlSubForm!txtSubTotal it causes an error.

thanks,