[Peter Jamieson]

OK, I'm not completely sure which particular problem(s) you need to solve
here.

How are you deciding which record to select? for example, do you have a
query that selects a single record?

Are you saying that the problem is that when the user opens the document,
they should see the current query result, but actually see the query result
they last saved?

Or are you saying that once the user has saved the document, when they
re-open it you want them to see the result they saved, but actually they are
seeing the current result?

(I think there are a few other possibilities but just let us know...)

Guessing that what you mean is that once the user has saved the document,
when they re-open it you want them to see the result they saved, there are a
few ways you could go, e.g.
a. get the user to "unlink" the fields before saving (ctrl-A then
ctrl-shift-F9), and they should probably also disconnect the data source,
then Save As - that's getting to be rather a lot so you'd probably need a
macro.
b. consider using a DATABASE field to insert the results. The user might
need to re-execute the database field (ctrl-A then F9, and to unlink the
results as in (a), they wouldn't need to disconnect the data source, but
they'd need to Save As)
c. get the user to perform the merge and save the resulting document. Or do
it from a Macro.

Since I'm not sure what you're really sasking there'ss little point in
offering any code (my stock is in any case rather limited) but if that
points you in the direciton you need to go, it may be worth your while
haveing a look around this group using Google groups.

Peter Jamieson

"RobGMiller" wrote in message
...
Office 2003,

I'd like to set a single record SQL in an access Query, or Table if
necessary, and then launch a word document which uses this data. I've set
the
doc up using the mail merge wizard. It works the first time but once the
document has been saved it returns the data from the original query the
next
time it is opened.

Simply put, the word doc will be used to display the query fields. The
user
needs to save this document using a different name.

In order to securely preserve the template, perhaps the doc can be saved
under a differnet formatted name and then opened with the correct current
query information.


Thanks in advance....

--
RobGMiller