Populating a table

[Farley]

I want to populate a table based on a checkmark being inserted on a form.
Example, if the check mark is present, i want the customer number (which
exists on the form) to be inserted in another table.

Not too competent in vba but am making progress. Not sure how to get the
information from the form [custno] to the new table [custno].

Thanx for your help

 

[Jackie L]

Farley,
If you are not real comfortable with vba then you can do a combination of query and vba. Create an append query to go from your current form/table to the new table with the criteria on the query to be Forms![frmCurrentForm]![CustNo] so that is the only record appended.

On a button or event on your form put:
Me.Refresh
IF Me.CheckBox = True then
DoCmd.SetWarnings False
DoCmd.OpenQuery "qryAppendCustNo"
DoCmd.SetWarnings True
End If

Hope this helps.