Form depositing information in two different tables

[guamlet]

I have a form that has a check box in it. Most of the data from the form goes into creating data in one table, but I want the check box to show up in another form. Can I do this?

 

[Corticus]

Hi guamlet,

Might not be the best way but,

You could insert a subform on your form that has this checkbox. Have the subform's recordsource be the other table that you need to have the check go to. Then add code to the on_click event of the first checkbox to have it click the other one. You could make the other subform and checkbox invisible so you don't confuse the user.

HTH,