I think you've got the syntax on the right side of the equals sign right,
except for my advice in # 4 below. But there are several problems on the
left side.
1. My instructions were to place a label on the report.
It looks as if you used a textbox.
Use a label.
2. When giving instructions such as "Create a Label. Set its properties
thus:", it's common to refer to the label as MyLabel.
The expectation is that the user will substitute the name of his/her
own label.
3. I instructed you to use the Caption property of the label.
If you have a label named Prevbalance, the syntax would be
Prevbalance.Caption
(If Prevbalance is a textbox, this will cause an error, because a
textbox doesn't have a Caption property.)
Since you have nothing on your report named MyLabel, and have an
instruction to Access to do something to MyLabel, it's understandable that
Access says "Object required", i.e. "I/you need an object named MyLabel."
4. This is not something I'd told you about before, but it looks as if your
form is named Date. Date is a reserved word in Access, which means Access
may have its own opinion as to the meaning of that term, which may well not
co-incide with yours. Personally, I avoid this problem by always starting
my form names with frm, so I would have called this form frmDate. You could
just as well name it DateForm, or DateRange. But naming it (or anything
else) just Date is asking for trouble you don't need.
"Scott Gorman" <sg***@comcast.net> wrote in message
news:42**********@127.0.0.1...
MyLabel.Prevbalance = Forms!Date!balance
This is the code I placed in the On open event procedure.
Prevbalance is the name of the text box, and balance is the name of the
box on the form where you input the previous balance.
When it runs, it errors out and says - run time error '424' Object
required.
Can you tell me where I went wrong.
Thanks for you patience with me...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
