Simple requery?

[Mike Green]

Hi all
I hope this is a simple question with a simple answer and I have just lost
the plot and cant think straight at the moment.

I have a single form based on a table, the user can click a button on the
form to print a report based on the record currently displayed in the form.
The form is updated prior to printing using an event in the OnClick Event
Procedure for the button. The simple question is how do I get the record
that is currently displayed to refresh/requery so that the other information
that has been updated from the OnClick event to now display? If I page
forward and then back to the record all is fine. I thought I could do it
with a simple requery but how do I just requery the current record?

Thanks in advance

Mike

 

[Marshall Barton]

I hope this is a simple question with a simple answer and I have just lost
the plot and cant think straight at the moment.

I have a single form based on a table, the user can click a button on the
form to print a report based on the record currently displayed in the form.
The form is updated prior to printing using an event in the OnClick Event
Procedure for the button. The simple question is how do I get the record
that is currently displayed to refresh/requery so that the other information
that has been updated from the OnClick event to now display? If I page
forward and then back to the record all is fine. I thought I could do it
with a simple requery but how do I just requery the current record?

Apparently you are not saving the data before running the
report. Maybe you are using the wrong method? A simple way
to save a record is to use:
If Me.Dirty Then Me.Dirty = False

 

[Mike Green]

Thank you

Yes that was the problem, with your help I have now sorted.