Hi,
In Access 2000, in a form displaying a student's information, I want to click a button that opens Word and populates a document with the information from just the student whose record was displayed on the Access form, rather than doing a merge with ALL of the student records.
I've been able to add a button that opens the Word document and merges the proper data fields, but of course it does so for all of the records in the table...because it's a merge. So right now the user is forced to "Find" the desired student record in the document and print it out.
I'm not too familiar with VBA...is there a way to do what I want to do without scripting? (I know, I know...time to learn VB already!!)
Thanks for any direction.
In Access 2000, in a form displaying a student's information, I want to click a button that opens Word and populates a document with the information from just the student whose record was displayed on the Access form, rather than doing a merge with ALL of the student records.
I've been able to add a button that opens the Word document and merges the proper data fields, but of course it does so for all of the records in the table...because it's a merge. So right now the user is forced to "Find" the desired student record in the document and print it out.
I'm not too familiar with VBA...is there a way to do what I want to do without scripting? (I know, I know...time to learn VB already!!)
Thanks for any direction.