I need help; this is wha i have
Dim action as String
...
...
action = "ADDED"
...
...
DoCmd.RunSQL "INSERT INTO MASTER_DIE_TABLE (M_DIENAME,M_COLORS,M_LENGTH,M_QUANTITY,M_LOCATION,M_ACTION,M_DATE) VALUES (Forms![D_ENTRY_F]![DIENAME],Forms![D_ENTRY_F]![colors],Forms![D_ENTRY_F]![LENGTH],Forms![D_ENTRY_F]![QUANTITY],Forms![D_ENTRY_F]![LOCATION],action,DATE())", -1
When I run this application I get a little screen asking me to enter the action value.
what I am doing wrong..! I got it working once and some how I didn't save it now I can remember what I did.. HA please help.
Dim action as String
...
...
action = "ADDED"
...
...
DoCmd.RunSQL "INSERT INTO MASTER_DIE_TABLE (M_DIENAME,M_COLORS,M_LENGTH,M_QUANTITY,M_LOCATION,M_ACTION,M_DATE) VALUES (Forms![D_ENTRY_F]![DIENAME],Forms![D_ENTRY_F]![colors],Forms![D_ENTRY_F]![LENGTH],Forms![D_ENTRY_F]![QUANTITY],Forms![D_ENTRY_F]![LOCATION],action,DATE())", -1
When I run this application I get a little screen asking me to enter the action value.
what I am doing wrong..! I got it working once and some how I didn't save it now I can remember what I did.. HA please help.