Thread: ODBC Refresh
View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Josvds Josvds is offline
external usenet poster
 
Posts: 9
Default ODBC Refresh

Hello,

I`m using office 2000 now and we will migrate to office 2003.
Now i`m checking the mailmerge connection between word 2k en access 2k
and it`s a dde connection.
In access 2k3 i would like to use ODBC but the only problem is:

When i`m using ODBC and i setup a query in the mailmerge you won`t get
any results till you click on the button to go to the next record or
the record before this one.

So when i have 3 records:

Id, Name, Last name
1, John, Jansen
2, Piet, Albertes
3, Bert, Jansen

When i`m standing on record 2 and put in the query i only want the Last
name Jansen. The record Alberts is shown till you go to antoher record.

The query works only when you go to another record.

Does anyone has a soulution?

Thnx
Jos