Report not updating data right away.

[mafhobb]

Hello.

I have a form that is bound to a table. One of the fields is called "Description".

A report is based on this form and there is a button to open the report on the same form.

I have an issue with the description field. If data is entered in this field and then the report is opened without closing the form and reopening it first, the report will show the data that was on the description field before the last update.

If the form is closed and reopened, the new data shows up in the description field and the report prints it fine.

It's as if the report was opening faster than the form can save the new data on the bound table and so it shows the old data.

How can I make sure that the report is showing the data that was just entered?

thanks

mafhobb

 

[mafhobb]

To the form or the report?

 

[Wiz47]

To the form or the report?

The form. Or, if you prefer, you could requery the specific field.

Me.textboxname.requery