Document not prefilling from form

[Guest]

Hi,

I have a form that when the information is completed, the user selects a
document from a dropdown box on the same form. When the document is selected,
they can click print preview to see the prefilled information from the form.
when they click print preview, the document is blank but if they click off
the record and click back then the information is filled in. How can I make
were the information fills while in the current record without having to
click back and forth? Please help!

Thanks Much!!

 

[JohnFol]

What is the document and where does it get the data? It sounds like it reads
from the table, and as the record has not beed saved, it appears blank.
Perhaps when they click the preview you can add some code in to save the
record?

 

[Guest]

I copied a document into an access report. I created field in the report to
prefill certain fields from the form. The list of documents the feed the
combo box are from a table. The record does save all the information and the
document will show the prefill information from the form but first the user
has to go out of the current record and then go back in. I want the
information to fill without having them leave the current record. Does that
make sense?

Thanks!

 

[Albert D. Kallal]

When you move to the other record, and back, you are forcing a disk write.

So, at the start of your code, simply force a disk write by placing the
following:

me.Refresh

And, by the way, if you want a user driven template and merge system for
word, give my word merge sample a try here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html