When checked, move to table

[valgore]

I have a table with a field called CheckBox. it has a checkbox in it. i want to say if it is checked, then import 3 other fields into a different table. so far i have

Private Sub CheckBox_Click()
On Error GoTo Err_SomeName
DoCmd.RunSQL "INSERT INTO TestCheckboxtable SELECT [AmexCurrent]![Merchant Name/Location] as [Merchant Name/Location], [AmexCurrent]![Carholder Name] as [Cardholder Name], [AmexCurrent]![CheckBox] as [CheckBox] FROM AmexCurrent WHERE Trim([AmexCurrent!CheckBox!] & '')<>''"
Exit_SomeName:
    Exit Sub
Err_SomeName:
     MsgBox Err.Number & Err.Description
     Resume Exit_SomeName
End Sub

but nothing is happening. any help would be appreciated

 

[valgore]

neither worked. i didnt get anything in the table

 

[dhookom]

Is the code even being run? What happens if you open a new, blank query and change its SQL view to

INSERT INTO TestCheckboxtable([Merchant Name/Location],CategoryCode)
SELECT [Merchant Name/Location], CategoryCode FROM AmexCurrent WHERE ChexBox=True

Duane
Hook'D on Access
MS Access MVP

 

[valgore]

im getting a compile error on the second [Merchant Name/Location]

 

[newguy86]

valgore,
Post the entire code again so we can take another look at what you are currently running.

Travis

http://www.enterprise.com

"Why would I ever want to learn about programming when Micorsoft products would be able to handle even the simplest of tasks. Oh...wait a minute...something's wrong with that statement?!

 

[PHV]

In fact, seems you have to provide the REAL names of the fields in the TestCheckboxtable and AmexCurrent tables ...

 

[GKChesterton]

Private Sub ChexBox_Click()

This event will not do what you want. It shouldn't exist in your module. Period.

Private Sub ChexBox_ ... k()

You don't want ANY events associated with Chexbox, as above.

You want your triggers to be either a button as DHookom says, or a form event (AfterUpdate, Close ...).

I suggest you get to a tutorial. The best thing I see at the moment is [link href=[URL unfurl="true"]http://www.informit.com/articles/article.aspx?p=21321&seqNum=3[/URL]]here.[/url]

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​

 

[dhookom]

GKChesterton,
Great article link! I had to strip off the beginning of the url to get Responding to Form and Report Events. I hope this link works better.

Duane
Hook'D on Access
MS Access MVP

 

[GKChesterton]

Thanks Duane! Another clue I should not try a career in web design.

[purple]If we knew what it was we were doing, it would not be called
research [blue]database development[/blue], would it? [tab]-- Albert Einstein[/purple]​