Fill word document with fields from Access form programmatically

Hi - i have a form called 'formpo' that allows users to enter information that we use for purchase orders such as date, order value, supplier name, purchase description, etc etc. when the user has filled in the information on the form i would like them to be able to click a button on the form screen that will take the values from the form and insert them into a specific word document, and have the values entered into a specific place on the word template. There is a lot of stuff out there but its not the best and its mainly about mailmerging it which i dont want to have to do because its a right pain in the proverbial behind. Has anyone done this before

Many thanks,

Rhys.

Assuming you have a word template, put a bookmark (in Word) where you want to add data from Access. The bookmarks can be named, (I think I'm right there) and then you can get to them from VBA behind the Access form.

Good luck, Vic

yep, found a document from microsoft on it eventually. that did the trick nicely.

Thanks Vic.