new record

D

dchristo

When I add a new record, most of my calculated fields are showing up as
#errors; however, if I add the minimal information to the record and close
the form. Once I reopend the form and go to the record all the calculations
are correct.

How do I refresh the screen or what should I do so they I do not have to
close the form then reopen to continue inputting data into the record
 
A

Allen Browne

The trick will be to identify what is causing the error, and address that.

For example, if yo have a text box bound to:
=DLookup("Field1", "Table1", "ID = " & [ID])
when you are at a new record, the ID field is probably Null. As a result,
the 3rd argument is just:
ID =
which is incomplete, and so generates an error. You solve that by using Nz()
to supply some value, e.g.:
=DLookup("Field1", "Table1", "ID = " & Nz([ID],0))
 
Top