Access Cannot Find Form

[mjcaestecker]

Greetings all,

First Post time! but there's a first time for everything.

I have a continuous subform (BooksFullSubCC) that is located on a tab in the main form (BooksFull). In BooksFullSubCC, there is a text box in the footer that sums up all the amounts of credit card charges to make a total with =Sum([Amount]). For some reason, I cannot pass the value from the text box to VBA or another text box on the main form because Access "cannot find the form"

Here's the code

Private Sub TabCtl93_Change()
        Dim Amount As Currency
    
    Amount = Nz(CCur(Forms!BooksFullSubCC!CCchargesTotal))
    
    Me!CCFees = Amount * 0.015
End Sub

Its really simple - Access should take the amount from the text box (CCchargesTotal) on the subform and then put it the result of some simple math into a text box on the other form.

When I try and change tabs to initiate the code, i get
"Run-time error '2450':

Microsoft Access cannot find the referenced form 'BooksFullSubCC'."


Any thoughts???

I've checked the spelling, rewritten the code, everything. I even tried to make a text box on the main form with control source =[Forms]![BooksFullSubCC]![CCchargesTotal] but that didnt work either... :banghead:

Cheers,

-Martin

 

[RuralGuy]

A good reference for issues such as this: http://access.mvps.org/access/forms/frm0031.htm

 

[mjcaestecker]

Thanks a bunch RG! Just what I needed.

 

[RuralGuy]

Glad we could help.

 

[fluid]

A good reference for issues such as this: http://access.mvps.org/access/forms/frm0031.htm

Awesome guide...Thanks

 

[RuralGuy]

You're very welcome.