I've searched and viewed may videos and can't seem to get what I need.
I have a form with many buttons, I have a search button that will find a record, after I find the record I would like to click a button to add the current record (Cap_ID) in that form to a Projects table, field Project_Part. I would also like the button to ask quantity and to subtract that number from PartsTable. I'm trying to use et tblCustomers = CurrentDb.OpenRecordset("SELECT * FROM [Table1]")
Projects.AddNew tblCustomers![Cap_ID] = Me.Cap_ID.Value
Any help would be great!