Calculation field on a main form displays Error

D

DJJ

I have a calculation field on a main form that references the value of a
calculation field on a sub form. When the user scrolls to a new record the
calculation field on a main form displays "Error" because (I assume) there
is no value in calculation field on a sub form. Is there any way to get
ride of or hide the "Error"?

Thx
DJ
 
D

DJJ

DJJ said:
I have a calculation field on a main form that references the value of a
calculation field on a sub form. When the user scrolls to a new record the
calculation field on a main form displays "Error" because (I assume) there
is no value in calculation field on a sub form. Is there any way to get
ride of or hide the "Error"?

Thx
DJ
Click to expand...

I found an excellent solution:
http://www.4tops.com/ms_access_tips/serrmsg.htm

DJ
 
J

Jan Baird

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 
J

Jan Baird

Jan Baird is out of the country until September 20. Every effort will be
made to respond to messages, but please be patient.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to avoid the display of "#Error" in a calculated field 2
Calculated Field Error Msg 9
Not All Fields Update my Table from my Form 5
retriving a calculation from a sub-from 3
Sub form calculations not correct on main form 2
Unbound field calculation save in table 3
Inserting Calculation / Expression in a Form 2
data base connection runtime error 3211 1

Top