#Error in subform controls until data is input

[CW]

I have a tabbed page that includes 3 subforms. The link for all of them is
the Ref of the job (shipment).
The main purpose of the page is to allow input of Actual costs, suppliers
and the dates.
When I first go to this tabbed page, many of the controls which are to
display data drawn from other parts of the database (based on a variety of
tables, queries and DLookups) show #Error.
It is only by entering a value in one of the controls for Actual costs that
all these errors suddenly clear, and the correct data is then shown without
any problem at all.
How can I get the page to display the data when I first go to it?
Many thanks
CW

 

[Allen Browne]

If the controls where you enter something show #Error, it sounds like the
Default Value is incorrect. It could be for one of the controls on for form,
or it could be the Default Value of the field in the table itself.

If the calculated controls show #Error, one of the expressions needs
changing so it copes with null.

 

[CW]

Thanks, Allen.
I looked into each of those possible causes but couldn't get a solution.
What I have done for now is to add a Y/N field to the ActualCosts table,
then a checkbox on the part of the form that is based on this, labelled
"Clear the Errors".
As soon as that is ticked, thereby providing some input into the table, all
the #Error controls come alive and pull their data through from the various
sources.
It's a clumsy workaround (aka botch) but hey, it gets me out of trouble for
when the users need this new form on Monday morning!
Thanks for your help
CW

 

[鈴木　義美]

I have a tabbed page that includes 3 subforms. The link for all of them is
the Ref of the job (shipment).
The main purpose of the page is to allow input of Actual costs, suppliers
and the dates.
When I first go to this tabbed page, many of the controls which are to
display data drawn from other parts of the database (based on a variety of
tables, queries and DLookups) show #Error.
It is only by entering a value in one of the controls for Actual costs
that
all these errors suddenly clear, and the correct data is then shown
without
any problem at all.
How can I get the page to display the data when I first go to it?
Many thanks
CW

 

[Aaron]

Hi CW,

Try this KB article, to see if it gives you any clues for solving this
issue:

(ACC2000 Troubleshooting Tips for Error Values
http://support.microsoft.com/?id=209132

Note: This article applies equally well to other versions of Access.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

nice to meet u
sorry this is a test!
forgive me!

 

[Tom Wickerath]

Hi Aaron,

Nice to meet you too. You're forgiven as long as you use an official test
site the next time you want to conduct a test. Here you go:

microsoft.public.test.here

or, via the web interface:

http://www.microsoft.com/communitie...ault.aspx?dg=microsoft.public.test.here&exp=1


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________