Macro

[Guest]

Hi

I have a report on a form that is run by a macro. On the report I have a
Memo field. When the user clicks on the report to run the report for current
record, any information recently type on the memo field does not appear. The
user has to go to the next record, return and run the report again.

Does anyone know why they have to do this and how I can fix it?

Thanks

 

[John Vinson]

Hi

I have a report on a form that is run by a macro. On the report I have a
Memo field. When the user clicks on the report to run the report for current
record, any information recently type on the memo field does not appear. The
user has to go to the next record, return and run the report again.

Does anyone know why they have to do this and how I can fix it?

Thanks

A record currently being edited on a Form is just on the Form - not
yet written to the database.

I don't use macros much, but I think you can put a line in the macro
before it opens the report to save the current record: IIRC it's the
SaveRecord action.

John W. Vinson[MVP]