I have a table with six fields. I have a form for data entry to this table. One of the fields in the table is a date field. I would like to add a button to the form that would run a macro that would, after one record is entered, create four more records. These four records would be identical to the first, except that each would have the next date. For instance, the first record has the date 05/01/02. When the macro button is pressed, the four new records would have the following dates: 05/02/02, 05/03/02, 05/04/02 and 05/05/02. All information from the other five fields from the first record would be copied to the four new records. Is this possible? Thanks!
Mike
Mike
