I use a form to enter new data into a room booking database for the hire of rooms in a hall for events, and for a large part of my entries I have no problems because the entries are stand alone. The problem arises when a customer wishes to book repeat dates, usually not consecutive, but often on, say, the second Tuesday of each month, or on every Thursday of each month.
For that customer all the entries in the various fields on the form are identical except the date field. Now I can use "copy and paste" for the whole record and just change the entry in the date field, but that is not professional and is not always easy to teach to another person entering the data.
What I would like is to enter the data for all the fields for the first date record, and then when I move to the second record to have all the data (except the date) automatically populated by the data in the first record, so that all I now have to do is enter the new date.
How do I achieve this, if possible without programming in vba as I am not very proficient in that language.
Many thanks,
David