You can have two sql statements. Let me see if I understand; first you select the users and use the drop down box, then when the user selects an option, you want to then insert information into another table?

You can have 2 statements sure, the select is a select into a recordset, and to do the insert you can do connection.execute(SQL).

Brian

Brian