AutoLookup Queries and data in tables

[Guest]

I wonder if anyone can help me? I am a beginner with Access and need some
help.

I have created an AutoLookup query to automatically fill in customer address
details in a form but for some reason I cannot get this information to
physically show in the corresponding table. Therefore when I merge the
information from the table to a word document I cannot get details such as
the fax number to appear on the fax template.

I have tried telling the merge document to use a different data source,
which it does, but as soon as I exit the merge document and then re-enter it
- regardless of the fact that I save before exiting, it reverts back to the
original source document.

This being the case, I am trying to get the right information to be visible
in the table and avoid the mail merge problems.

Is there a way that I can have the details that are in the AutoLookup
visible in the data table itself?

Cheers,

GR

 

[Duane Hookom]

You should merge from a saved query that contains all of the tables that are
storing all of the information (fields) you need in the merge. I would
recommend you reconsider using lookup fields since they are confusing.

 

[Guest]

Dear Duane,

Thank you for responding. I have tried the merging from a query but for
some reason, if I exit the document and then re-enter it, word resets where
it is sourcing the information and reverts back to a table instead of the
query.

I am guessing I may need to create some sort of macro to ensure that the
right source data is used, but I don't know how to do it or where to put it
since I am basically teaching myself Access.

Any thoughts?

Kind Regards and Thank you once again,

Gwen

 

[Duane Hookom]

Your problem is in Word, not Access. If you continue to have an issue,
consider posting a question in a Word news group.