commanderbob
Technical User
Ok then here it is..
I have a form on which you can select things what you want to search on in the database. The database has 4 tabels linked with MANY TO ONE links between them in a line.
When you select the search button on the form it opens a record form with
docmd.openform formname, , ,SQL where line
What I need to do is put a button on the record form which will mail merge the data currently select in the form (which is based on the SQL WHERE line within the previuos form)..
Dose that make sence?
I though I'd be able to simple use the same string as I did for opening the form, however that isn't an option for the
docmd.runcommand wordmailmerge
So all and any help would be great.
Thanks
Bob
I have a form on which you can select things what you want to search on in the database. The database has 4 tabels linked with MANY TO ONE links between them in a line.
When you select the search button on the form it opens a record form with
docmd.openform formname, , ,SQL where line
What I need to do is put a button on the record form which will mail merge the data currently select in the form (which is based on the SQL WHERE line within the previuos form)..
Dose that make sence?
I though I'd be able to simple use the same string as I did for opening the form, however that isn't an option for the
docmd.runcommand wordmailmerge
So all and any help would be great.
Thanks
Bob