Adding records to multiple tables

[Leslie]

I have a form with a list box. Based on what is selected in list box will
determine which table is written to.

 

[Alex Dybenko]

Hi,
just build insert (append) query SQL string, based on selection in you
listbox,and then run it using currentdb.execute strSQL

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com