Hi hopefully someone can help a newbie,
I'm having an issue with mail merge into word from a query in my database. The database is to be used to automate (to a degree) the creation of test reports, products have multiple tests and tests have multiple products.
The database has three tables, Product (the item under test), Test (holds the information on the test) and Link which brings both together.
I have a query that pulls in information from all 3 tables which is then mail merged into word to fill in the gaps to make a report. I have a button on the Link form which opens the query. The query has a field 'LinkID' which is the primary key of the table Link, in the criteria I have entered [Forms]![Link]![LinkID].
This works well and brings a query up based on the record that can be seen in the Link form. The problem appears with the mail merge, without the criteria or the criteria set to a number (eg. 1) the mail merge works fine, with the form related criteria [Forms]![Link]![LinkID] the mail merge doesn't work. Word asks for the data source and Access informs me it has failed.
My best guess is that word interogates the query but isn't prepared for the dynamic criteria, does anyone know a way around this. Thanks for the help, I'm very rusty at this.
I'm having an issue with mail merge into word from a query in my database. The database is to be used to automate (to a degree) the creation of test reports, products have multiple tests and tests have multiple products.
The database has three tables, Product (the item under test), Test (holds the information on the test) and Link which brings both together.
I have a query that pulls in information from all 3 tables which is then mail merged into word to fill in the gaps to make a report. I have a button on the Link form which opens the query. The query has a field 'LinkID' which is the primary key of the table Link, in the criteria I have entered [Forms]![Link]![LinkID].
This works well and brings a query up based on the record that can be seen in the Link form. The problem appears with the mail merge, without the criteria or the criteria set to a number (eg. 1) the mail merge works fine, with the form related criteria [Forms]![Link]![LinkID] the mail merge doesn't work. Word asks for the data source and Access informs me it has failed.
My best guess is that word interogates the query but isn't prepared for the dynamic criteria, does anyone know a way around this. Thanks for the help, I'm very rusty at this.
