I have a form that includes multiple field entries such as customer name, date of arrival, company name, etc. I would like to add a macro command that will allow for duplicate date entries without clearing out the whole form. I am currently using Access' duplicate command in the design tab which will save all of the data but one must erase the current date and fill it out with a new one. I would like the command to save all of the current data but display the date field as blank when the button is pressed. Any ideas on how to do this? I am using Access 2010.
Ex: Customer Name- John Doe Customer Name- John Doe
Date of Arrival- June 4th (when one presses the command Date of Arrival-
Company Name- Coca-Cola it will save the data but display..) Company Name- Coca-Cola