Auto-fill Dates

[Guest]

Hi

I have a Room Booking form which requests the administrator to enter the
start date of the room hire followed by the duration. In the next page the
administrator must choose which rooms to use for the booking. Currently each
date of the booking must be entered alongside the room required (they may
want a different room for each day).

To save time and errors, Is there a way that after entering the start date
and duration, the list of dates can be auto-filled in the rooms page e.g.

Room Booking form: -
Room Hire Start 18/04/06
Duration 4

Room Request Form:-
a record created for 18/04/06
19/04/06
20/04/06
21/04/06

we can then choose, using a drop down, the room required for each booking day.

Behind the scenes these are 2 tables linked by the RBID field. Room Booking
(ONE) & Room Request (MANY)

If you have another suggestions on how to manage this booking detail please
let me know.

I hope this makes sense.

Many thanks for your time.

Kerry.

 

[Ron2005]

Basically, either through specific VBA code that does the append or
through a loop that executes an append query.

In both cases the append query will create the record with whatever
info and (key) information it needs and will add (loop count - 1 )
to the date that you have entered.

You may need to do a requery on your form to show the new records.