run time error '3464'

[Guest]

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)

 

[Rick Brandt]

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)

Numbers don't get quotes around them.

 

[Guest]

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

 

[Guest]

thanks ):

 

[Rick Brandt]

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

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