Did you see the post by Ajax (Post # 5)? The "SELECT" query is missing the "FROM" clause; what table to pull the data from.
The SQL from your post #1 should look like
Code:
strsql = "INSERT INTO [WorkQueT] ([RequestID], [LocID], [DeptID], [SystemID],
[AssetID], [ComponentID], [PartID], [OperatorID], [healthID], [WorkID], [Summary], [Desc], [PriorityID], [RequestDate], [review], [done] )"
strsql = strsql & "SELECT [RequestID], [LocID], [DeptID], [SystemID], [AssetID], [ComponentID], [PartID], [OperatorID],
[healthID], [WorkID], [Summary], [Desc], [PriorityID], [RequestDate], [review], [done] FROM RequestT"
strsql = strsql & " WHERE cboreview='Proceed'"
how do I get the execute sql to only update the active record on the header of the form?
That is where the PK field comes in or you have a way to indicate which is the active record (as in a check box).
(the WHERE clause)