Hi There,
I want to retrieve a value from a table. The value have to go to an other field on the same form.
However, its not working because of error ''syntax error, operator is missing".
The value in the table (FactuurFactuurnummerFN) is text and contains letters and numbers.
Here is the code:
Dim db As Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("SELECT * FROM factuur WHERE FactuurFactuurnummerFN=" & Me.factuurnummerFN)
Me.StatusFactuur = rs!Factuur_status
End sub
Can someone help me and explain whats going wrong?
I want to retrieve a value from a table. The value have to go to an other field on the same form.
However, its not working because of error ''syntax error, operator is missing".
The value in the table (FactuurFactuurnummerFN) is text and contains letters and numbers.
Here is the code:
Dim db As Database
Dim rs As DAO.Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("SELECT * FROM factuur WHERE FactuurFactuurnummerFN=" & Me.factuurnummerFN)
Me.StatusFactuur = rs!Factuur_status
End sub
Can someone help me and explain whats going wrong?