Program won't recognize variable

[sorensok]

I am writing some code to automatically print out a form. The problem I ran into is I have an if statement that reads:

If rsMyRS!TotalBalanceAmount > 0 Then
...

My problem is that the TotalBalanceAmount is what I named the textbox the holds the formula: =Sum(Rate)

My program refuses to recognize TotalBalanceAmount. I tried typing it like rsMyRS![=Sum(Rate)], but that doesn't work either. The program does recognize the variable Rate, though (as in rsMyRS!Rate). Any idea how to get it to recognize TotalBalanceAmount?

Thank you in advance,

Kyle

 

[jebry]

Hi!

Try Me!TotalBalanceAmount.

BTW, what error are you getting?

hth
Jeff Bridgham
bridgham@purdue.edu

 

[sorensok]

I set up my code like this.

Set dbMyDB = CodeDb
Set rsMyRS = dbMyDB.OpenRecordset("Clients&quot

Me!TotalBalanceAmount won't work how I have it set up. Do you think I should set it up different?

The error is:
Item not found in this collection.

Thanks,
KYLE

 

[sorensok]

I figured it out. Thanks for the help

KYLE

 

[JeremyNYC]

Kyle,

It's usually best to post what the solution is. Sometimes it's a bit embarassing (like if you've spelled something wrong), but it helps people who look at this thread later to learn.

jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.