update query on form

M

magmike

I don't want to update every record in the table. Just the record that
is the current on the main form, with the data from the subform where
Main.ID = Subform.ID .

Also, there is a check box next to each field in the subform. I only
want to update the fields in the main form/table where the
corresponding fields on the subform have check boxes selected.

These check boxes are named, Field1_Select, and so forth. They are
unbound.

Thanks!


If possible, I'd like to be able to do this, where there isn't a
matching ID field in the subform. I would just want to update the
current main record, with the current subform record.

Thanks!
 
Top