Hello, spent too many hours at the screen today.
I wonder if someone could help.
I have the line:
I want to replace the part where I refer to the textbox: Me.[txt_Gemini_Prop_Deduct_Lan_Ref] with a Variable I have defined as: fileStoreID
I'd much appreciate if someone could provide the correct line. Thank you very much Mark
I wonder if someone could help.
I have the line:
Code:
CurrentDb.Execute "Update [tbl_Invoice] SET [Inv_Scan_FilestoreID] = '" & Me.[txt_Gemini_Prop_Deduct_Lan_Ref] & "' WHERE Inv_ID = " & Me.txt_100
I want to replace the part where I refer to the textbox: Me.[txt_Gemini_Prop_Deduct_Lan_Ref] with a Variable I have defined as: fileStoreID
I'd much appreciate if someone could provide the correct line. Thank you very much Mark