Hi all,
Im new to programming on Access and have hit a brick wall with this, im trying to select a value from a table, but i keep getting the error runtime error '3075': syntax error(missing operator) in query expression. any help fixing my mistakes would be great.
strSQL1 = "SELECT[Stock]FROM[tbl_barstock]WHERE[Traceability Code]='" & Me.txt_traceability_code.Value & "'"
Im new to programming on Access and have hit a brick wall with this, im trying to select a value from a table, but i keep getting the error runtime error '3075': syntax error(missing operator) in query expression. any help fixing my mistakes would be great.
strSQL1 = "SELECT[Stock]FROM[tbl_barstock]WHERE[Traceability Code]='" & Me.txt_traceability_code.Value & "'"