Hi John. I did so. The records from tblOffers move to tblOrders fine!
Thanks. I got some problem moving records from tblOfferDetails to
tblOrderDetails.
I get a "run-time error '3134': Syntax error in INSERT INTO statement".
It point to:
DoCmd.RunSQL strSQL
The whole INSERT stataments is now like this:
strSQL = "INSERT INTO tblOrderDetails " & _
"(OrderID, ItemID, ItemQuantity, ItemDiscount) " & _
"(SELECT " & lngOrderID & " As OrderID, " & _
"ItemID, ItemQuantity, ItemDiscount " & _
"FROM tblOfferDetails " & _
"WHERE OfferID=" & Me.OfferID & ");"
DoCmd.RunSQL strSQL
Regards,
Theodore
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
