new record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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))
 
Back
Top