Command Button - Module

[nia]

I am trying to use a statement (attached to a command button) in a module to populate a history table with information from my current form:

dbs.Execute ("INSERT INTO FA_History ( FAHI_AcctNumber, FAHI_Amount, FAHI_InvNumber, " & _
"FAHI_PostDate, FAHI_HistType, FAHI_EffDate, FAHI_DeptID, FAHI_PersonID, FAHI_StampDate ) " & _
"VALUES (AlarmPay.AcctNumber, AlarmPay.AmountOwed, AlarmPay.InvNumber, Now(), " & _
"'TAX', Now(), 'PD', 'PD', Now());

I get a syntax error, but the whole statement is highlighted. I search several platforms trying to find a solution.

 

[JohnYingling]

I'll assume this is VB.
Either put Call in front of the statement or drop the outside parens () because you are calling a SUB without the CALL staement not a FUNCTION...and is that a semi-colon there at the end of the statement? What the heck is that?

Call dbs.Execute  ("INSERT INTO FA_History ( FAHI_AcctNumber, FAHI_Amount, FAHI_InvNumber, " & _
    "FAHI_PostDate, FAHI_HistType, FAHI_EffDate, FAHI_DeptID, FAHI_PersonID, FAHI_StampDate ) " & _
    "VALUES (AlarmPay.AcctNumber, AlarmPay.AmountOwed, AlarmPay.InvNumber, Now(), " & _
    "'TAX', Now(), 'PD', 'PD', Now())
'******** O R ************************
dbs.Execute  "INSERT INTO FA_History ( FAHI_AcctNumber, FAHI_Amount, FAHI_InvNumber, " & _
    "FAHI_PostDate, FAHI_HistType, FAHI_EffDate, FAHI_DeptID, FAHI_PersonID, FAHI_StampDate ) " & _
    "VALUES (AlarmPay.AcctNumber, AlarmPay.AmountOwed, AlarmPay.InvNumber, Now(), " & _
    "'TAX', Now(), 'PD', 'PD', Now()

http://WWW.VBCompare.Com