I want to be able to enter a record in a form, then write a macro to go to the new record in the form's corresponding table. The next step is to use the Officelinks 'Merge with Microsoft Word' function, populate a Word form with the data from Access (and additional empty fields), and print it out.
The reason I am doing this is that I want to print out a complex form with only some of the fields filled in; it seems Word is better at printing forms with empty fields.
The form is called 'Service Order', and the underlying tables are 'Workorders' and 'Contacts', and corresponding primary keys of 'WorkorderID' and 'COntactID'.
Any help is a appreciated.
The reason I am doing this is that I want to print out a complex form with only some of the fields filled in; it seems Word is better at printing forms with empty fields.
The form is called 'Service Order', and the underlying tables are 'Workorders' and 'Contacts', and corresponding primary keys of 'WorkorderID' and 'COntactID'.
Any help is a appreciated.