All I need is the correct syntex for the adoOrder.recordset.addnew line:

Private Sub cmdCartit_Click()
'this button is supposed to take whatever
'was ordered from item listed and put it in cart
' by creating a temporary database that will be seen on
'the final form

Dim Quantity As String, ID As String, Product As String, Price As String, ExtendedPrice As String

'grab the information off the GUI

Quantity = txtQuantity.Text
ID = lblID.Caption
Product = lblToolOrdered.Caption
Select Case optDealerOption(index).Value = True
Case index = 0
Price = lblPrice(2).Caption
Case index = 1
Price = lblPrice(1).Caption
Case index = 2
Price = lblPrice(0).Caption
End Select
ExtendedPrice = lblExtendedPrice.Caption

'use the ado control to enter data into feild.
adoOrder.Recordset.AddNew ([fldID],[ID] & [fldProduct],[Product] & [fldPrice], [Price] & [fldExtendedPrice],
[ExtendedPrice])

You can assume that the items in the brackets with fldprefix are the feilds of the db
and that the second[*] are supposed to be the strings created above.