Write to a table

[David#]

I have a form that allows user to display a list of names
(in a subform) based on one criterium selected from a
combo box on the main form. I need to write the names to a
table for use later. Can't seem to get there.

This also needs to work like a "make table" query because
the resuting table will change to hold entirely new data
each time this user form is run. (The resulting names
will then be used in a Mail Merge in Publisher).

I'm displaying the names in the subform using "Requery" on
the After Update event of the criteria combo box. Can
these names be written to a table?

Thanx - David

 

[John Vinson]

I have a form that allows user to display a list of names
(in a subform) based on one criterium selected from a
combo box on the main form. I need to write the names to a
table for use later. Can't seem to get there.

This also needs to work like a "make table" query because
the resuting table will change to hold entirely new data
each time this user form is run. (The resulting names
will then be used in a Mail Merge in Publisher).

I'm displaying the names in the subform using "Requery" on
the After Update event of the criteria combo box. Can
these names be written to a table?

Thanx - David

I'd be very hesitant to do a MakeTable for this purpose. You can do a
Mail Merge in Publisher *FROM A QUERY* - it is NOT necessary to create
a new table for that purpose!

Try just creating a Query using the combo box as a criterion:

=[Forms]![mainform]![comboboxname]

on the criteria line. You should be able to do the mail merge from
that query.

 

[David]

When in Publisher, if I select "Mail Merge" and Navigate
to the Access database, I'm offered only the Table names
as selections. I don't see where I can pick up a query to
use in the merge. That's why I thought a "Make Tbl" would
be necessary. Where can I select a query or the results
thereof?

dd

-----Original Message-----

I have a form that allows user to display a list of names
(in a subform) based on one criterium selected from a
combo box on the main form. I need to write the names to a
table for use later. Can't seem to get there.

This also needs to work like a "make table" query because
the resuting table will change to hold entirely new data
each time this user form is run. (The resulting names
will then be used in a Mail Merge in Publisher).

I'm displaying the names in the subform using "Requery" on
the After Update event of the criteria combo box. Can
these names be written to a table?

Thanx - David

I'd be very hesitant to do a MakeTable for this purpose. You can do a
Mail Merge in Publisher *FROM A QUERY* - it is NOT necessary to create
a new table for that purpose!

Try just creating a Query using the combo box as a criterion:

=[Forms]![mainform]![comboboxname]

on the criteria line. You should be able to do the mail merge from
that query.


.