G
Guest
I am trying to create a macro that would allow the user to use one button to
merge the current record they are on in the form to a word document. When I
am trying to do this I am using a select query that has the criteria of
[Forms]![General Info]![Record #]. When I then merge this query, a box comes
up asking me which table I am merging the data from. I do not want to merge
the data from a table, it is from a query. What I am finding is that I can't
merge a select query that has criteria that needs to be found or entered.
merge the current record they are on in the form to a word document. When I
am trying to do this I am using a select query that has the criteria of
[Forms]![General Info]![Record #]. When I then merge this query, a box comes
up asking me which table I am merging the data from. I do not want to merge
the data from a table, it is from a query. What I am finding is that I can't
merge a select query that has criteria that needs to be found or entered.