Passing Criteria to a Query

[HAFPT]

Looking for some help on a Mail Labels database I'm working on for a Paper Company.

I created a form for the user to select what Address Book records they want Mail Labels for. The form has three criterias, two text boxes for Address Type and Country then I have an Option Group with Option Buttons for each Paper Commodity (Pulp, Paper, Newsprint, Board, etc..)

I want to pass this info to a Make Table Query which creates a table, then Open Word which has a Labels template linked (Mail Merge) to this Mail Labels table in Access.

I have another form just like this form I'm working on that has the same filters on it but only displays the data in the detail section of the form. This form is using the following code in the event procedure:
If FilterCountint > 0 Then
Me.Filter = Filterstr (The code builds this Filterstr for Where stmt)
Me.FilterOn = True
Me.Requery

I saw the threads about the "Passthroughfixup" but wasn't sure how or if this was what I needed to use.

I hope someone can help or point me in the right direction.
Thanks

 

[Pat Hartman]

I wouldn't use a Word mail-merge to create labels, I would use Access. Use the wizard to build your labels. That way you won't need the make-table query. You can just use the select query as the RecordSource for the labels.