Hi there.

I have a search query that uses a form field to display 1 record (searches their userID).

I then want to click a command button and merge their personal details (firstname, surname, address etc) into a word document.

I have tried different ways of achieving this (RunApp macros, VBA) but whatever I do, when Word tries to open it prompts me for the userID (as a parameter query does when you run it).

When I enter the userID, Word open with the correct data merged.

Anyone know of the best method to do this without Word prompting me for a userID.

Thanks in advance

James Brown