G
Gary Dolliver
Hi all,
I am trying to run an SQL statement via code and am not able to get it to
work.
I have an open form, it captures a number in field "Item_ID" and an after
update event is called running the following VB code:
DoCmd.RunSQL "UPDATE Items SET Items.Step1 = Now() WHERE ((Items.Item_ID) =
(Forms![RECEIVING_PRODUCTION_Step_Check_In]![Item_ID].value))"
I do not get any error messages, but I cannot get field Step1 to update with
a current date.
I went into the query editor, made an update query with the following SQL
and got it to work:
UPDATE Items SET Items.Step1 = Now()
WHERE (((Items.Item_ID)=[Item id?]));
Why will the VB not work? Any help always appreciated, thanks!
-gary
I am trying to run an SQL statement via code and am not able to get it to
work.
I have an open form, it captures a number in field "Item_ID" and an after
update event is called running the following VB code:
DoCmd.RunSQL "UPDATE Items SET Items.Step1 = Now() WHERE ((Items.Item_ID) =
(Forms![RECEIVING_PRODUCTION_Step_Check_In]![Item_ID].value))"
I do not get any error messages, but I cannot get field Step1 to update with
a current date.
I went into the query editor, made an update query with the following SQL
and got it to work:
UPDATE Items SET Items.Step1 = Now()
WHERE (((Items.Item_ID)=[Item id?]));
Why will the VB not work? Any help always appreciated, thanks!
-gary