#Error

[DiveKennene]

Hello,

I have a form with one of the text boxes value is set to:

=DateAdd("d",[Days],[LastRpk1])

where [Days] is a field in a table that is bound to a text box on the form with a default value of 120. The form is set to automatically open in a new record. Before I begin adding data to the form, the text box with the above formula in it shows #Error. Once I start typing to add info for the new record, the #Error disappears and the text box behaves as expected. How do I stop the #Error message from showing up in the new record? Any help would be greatly appreciated.

Thank you,
Matt

 

[boblarson]

One other potential thing that could be causing you a problem is that when you use a "calculated field" as a control source you have to make sure that the field names and the control names are not named the same.

 

[DCrake]

Simple Software Solutions

When using Bound forms and adding new records on open event the file marker goes to EOF and waits for an entry to appear in the new record. As soon as this occurs then the file marker moves from the EOF to the Last record: A table appears as follows

-------------------------
BOF
-------------------------
first record
Second record
....
Last record
-------------------------
EOF
-------------------------

When you use recordsets you usually test for EOF and/or BOF this is how it detects when a table does not contain any records.

CodeMaster: