Box Updating

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

Guest

When I carry out a report, the record which is open is not included on the report unless I go out of Access and reload it.
Is there a way of updating the boxes as soon as they are typed into?
Thanks
 
When you enter a record using a form, the record is not saved until you
either explicitly save it, move to a different record, or close the form. If
you're opening a report via a command button on the form, and want a newly
entered record to be included in the report, you need to save the record
first.

Try adding the following lines to the code behind your command button,
before the line that opens the report ...

If Me.Dirty Then
Me.Dirty = False
End If

--
Brendan Reynolds (MVP)
(e-mail address removed)


Ali said:
When I carry out a report, the record which is open is not included on the
Click to expand...
report unless I go out of Access and reload it.
 
Back
Top