Hello,
I am running the below code, but getting an error.
DoCmd.RunSQL "UPDATE [tbl_Running_Open_Transaction] SET [tbl_Running_Open_Transaction].[Matched] = 1 WHERE [tbl_Running_Open_Transaction].[ID] = [tbl_Matches].[TBL_ID] ;"
I have a list of IDs in the tbl_Matches Table that are in column TLB_ID. I am trying to have the check box ( [tbl_Running_Open_Transaction].[Matched] ) checked if the AutoNumber ID is in the list in tbl_Matches.
It is giving me an Enter Parameter Value Error asking for tbl_Matches.TBL_ID
Any clue as to why it is not recognizing this field?
Thanks,
I am running the below code, but getting an error.
DoCmd.RunSQL "UPDATE [tbl_Running_Open_Transaction] SET [tbl_Running_Open_Transaction].[Matched] = 1 WHERE [tbl_Running_Open_Transaction].[ID] = [tbl_Matches].[TBL_ID] ;"
I have a list of IDs in the tbl_Matches Table that are in column TLB_ID. I am trying to have the check box ( [tbl_Running_Open_Transaction].[Matched] ) checked if the AutoNumber ID is in the list in tbl_Matches.
It is giving me an Enter Parameter Value Error asking for tbl_Matches.TBL_ID
Any clue as to why it is not recognizing this field?
Thanks,