Duplicating Date Entries in a Form

[sosneedaccesshelp]

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

[Ruegen]

You could have several named and unboundtext boxes on the field.

when you click the button it fires the on click event and you could use macro code or vba to fill the fields in the record

I would use vba

click button and..

[CustomerName] = me.txtCustomerName
[date_arrival] = date() <-date function for current date that replaces old date with current one
[CompanyName] = me.cboCompany (you could type but if you commonly use companies over and over you could make a combo box that pulls from a company name table)

then move to the next record.

[June7]

I am not familiar with 'duplicate command in the design tab' - do you mean a command button on form with embedded macro? Could probably have code in the same macro to set the date field to Null. This would require the SetValue action. From macro design, click "Show All Commands" to present the SetValue.

However, like Ruegen, I don't use macros, only VBA.