Populate Access table

  • Thread starter Thread starter Farley
  • Start date Start date
F

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
 
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
Click to expand...

Dim strSQL as String
Dim strCustNo as String

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