Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Macro to move from form to a table

Status
Not open for further replies.

rdiamond

MIS
Feb 27, 2003
1
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top