Question select multiple items from query to update another table

[freezeb]

I have a query that is made up of multiple tables. The data displays fine but I need to be able to create a form that will allow me to select only certain records from the query and then update another table with those records. Thanks in advance.

 

[pbaldy]

You could use a multiselect listbox to display the records and code like this to add to the other table:

http://www.baldyweb.com/MultiselectAppend.htm

 

[freezeb]

Thank you this will be a big help.

 

[pbaldy]

No problem; post back if you get stuck. Welcome to the site by the way!

 

[freezeb]

Funny how when you get an answer to one question you find by working things a bit you get answers to many others. Your answer opened all kinds of new things for me. Again thanks.