how do i create a on the fly query

[apples76]

I want to simplyfi the method of merging data to word. presently i have created a command button to run a make table query and then merge the data from word (template setup). the user has to press the button click yes to the various warnings then input the referance no. followed by more warnings then eventually into word and then follow more commands.......

the query looks up data from several tables all linked by a unique identifier. (autonumber_option_tbl)

i think i have the code examples for the merge but not for creating the query could someone please help with explanations so that i can understand the commands.

i am learning as i go so this is taking some time........ doh.


thanks in advance

 

[KeithG]

I would do so research on the QueryDef object.