Update multiple tables from one form

[medic133]

I have a form that has nothing but several option groups, each with choices of 1, or 2 (none of the option groups are required so null is also an option). I like the look of this form as it is very user friendly (users just point and click). What I think I would like to do is have another table that lists the name of the option group if the option group is selected (choices either 1 or 2). I would like to do this to aid in creating a crosstab query for a report. I have attempted to write If, Then statements in the code of the form to store a string (name of the option group) in this other table, however I've been unsuccessful. I've tried to refer to this other table with the format [tables].[tablename].[fieldname] and several other similar formats without success. Is there a relationship problem or can this be done? Essentially, I'm wanting to store values in multiple tables from one form. Thanks in advance!!

 

[mikey69]

I think this sounds like a DAO job. You can open as many tables as necessary, one after the other, update each and then close it. You use the OpenRecordSet, AddNew, Update, Close methods.