I am new to access. I have also read most of the post on "append data" this is my problem.
I need to append 2 types of data product and price
I have read previous post and it has helped greatly.
I am using this code
Private Sub product_Click()
Dim db As Database
Dim rs As DAO.Recordset
Set db = CurrentDb()
Set rs = db.OpenRecordset("SELECT * FROM CustomerOrder WHERE(Product = """ & Me.Product & """)")
If rs.EOF Then
.Fields("Product") = Me.Product.Text
I can only add the product but i also need to add the price of the item