Capturing New Information From the Form into a Query / Report

  • Thread starter Thread starter dbain3175
  • Start date Start date
D

dbain3175

I'm using Access 97, what I'm trying to do is to have an associate
enter information into a form, once complete then click on a button
that will generate the letter to the customer.

The problem that I'm having is that unless they click to the next
record and then click back, the query isn't picking up the data,
therefore the report is blank.

I would assume there's a very easy solution to this that doesn't
involve going to another record and coming back and would appreciate
any assistance with this.
 
The information isn't actually written to the table until you move off the
record. There are several workarounds, but the easiest is to first force a
save in the event that you are using to generate the report.
 
In the Event Procedure for the button's Click event, put

If Me.Dirty = True Then Me.Dirty = False

That will save the current record if it hasn't already been saved.
 
Back
Top