run time error '3464'

S

SIN

hi,
i dont understand why i have that type of error, because colume have the
same data type (number).
thanks,

currencySQL = "SELECT * from Currencys "
currencySQL = currencySQL & " where Currency_id = '" & Me!Currency_Id & "'"

Set rsCurrency = dbs.OpenRecordset(currencySQL)
 
R

Rick Brandt

SIN said:
hi,
i dont understand why i have that type of error, because colume have
the same data type (number).
thanks,

currencySQL = "SELECT * from Currencys "
currencySQL = currencySQL & " where Currency_id = '" & Me!Currency_Id
& "'"

Set rsCurrency = dbs.OpenRecordset(currencySQL)
Click to expand...

Numbers don't get quotes around them.
 
S

SIN

sorry but i dont understand what you mean.
can you attach me to information about error type and solution?
thanks
 
R

Rick Brandt

SIN said:
sorry but i dont understand what you mean.
can you attach me to information about error type and solution?
thanks
Click to expand...

You are putting single quotes around the value being pulled from your form.
That will make it a Text value rather than a Number value. Remove those
quotes and the query will work.


currencySQL = "SELECT * from Currencys "
currencySQL = currencySQL & " where Currency_id = " & Me!Currency_Id
 
Top