Hi Expert,
I have a Template Form which I am using for cost estimation. It contain some default values for itemID, itemName, Price, Qty, TotalCost and QuoteID. Once the user completes the cost estimation for a particular QuoteID, I want the values to be saved and then be able to make new entries for new QuoteID and then keep saving the form records as the user perform new estimations in this costing form.
But presently I am not able to save new records on form, only the existing values get overwritten. I have added a Save command button, but that doesn't help to save new record in the form.
All fields in my form belong to a table and doesn't have any textbooks.
I am still learning Access so any help or directions would be greatly appreciated. Thanks.