access vba - Copy Record From One Form to Another -

i have form list of records location information. each record starts checkbox. user able select multiple records interested in clicking checkboxes , click submit button on bottom pass selections through , copy them new records form. how in vba?

first, data main form fed in through table. created new field , assigned boolean data type show checkbox icon next each record in form. checked on default first issue. how records unchecked default?

second, assuming figure out checkbox issue, how have access pull desired records new form via coded submit button?

if include checkbox boolean table field, can update records , when user clicks command button, either pass sql clause "where fieldy =true" parameter "docmd.openform "secondform", acnormal, , , , , "where fieldy =true". in form open event, use me.openargs clause filter records.

or have second form record source include clause "where fieldy =true" opens records.