Populate Access table

[Farley]

I want to add information into another access table when a check mark is
placed in a box. I want to add the [custno] from the form into another
access table.

so far i can figure

if me![checkbox] = true then
(this is where i need help)
end if


Any thoughts??

Thanx
Tom

 

[Dan]

I want to add information into another access table when a check mark is
placed in a box. I want to add the [custno] from the form into another
access table.

so far i can figure

if me![checkbox] = true then
(this is where i need help)
end if


Any thoughts??

Thanx
Tom

Dim strSQL as String
Dim strCustNo as String

strCustNo = Me!txtCustNo
strSQL = "INSERT INTO tblMytable ([custno]) VALUES (" & strCustNo & ")"
DoCmd.RunSQL strSQL