Insert Into error ...

[tinymind]

I have a simple Insert statement that does not want to run ..

Dim dbs As Database
Dim staff As String

Set dbs = CurrentDb()
Set order = Forms![frmOrder]![OrderNo]
dbs.Execute ("Insert into tmporderList (OrderNo) value (Order);&quot

I am new to VB and SQL and can't understand what it is that I am doing wrong ...??

Tiny

 

[GHolden]

You need.......

if Order is a NUMBER

dbs.Execute ("Insert into tmporderList (OrderNo) value (" & Order & "&quot

if Order is a STRING

dbs.Execute ("Insert into tmporderList (OrderNo) value ('" & Order & "');&quot

 

[tinymind]

Thanks...

thats is exactly what I wanted to do ...

Tiny