saving multiple records in a form

[gwoman]

I inherited a database that manages reservations for creating manifests. Currently on the reservation form the user can only enter a reservation one day at a time. Being that there are several employees that have reservations everyday they are requesting that I add functionality to enter multiple reservations at one time ... for instance John Doe needs a reservation for the month of February ... or maybe for the rest of the year. I have created the objects to capture start date and end date ... however I am struggling with how to save the multiple records.
Any suggestions would be greatly appreciated ... thanks!

gwoman

 

[Remou]

It should be possible with queries, append or update, as appropriate.

strSQL="INSERT INTO tblReservations (ID, User, StartDate) VALUES (" & Me.ID _
& ",'" & Me.User & "'#" & Format(Me.StartDate,"yyyy/mm/dd") & "#)"
CurrentDB.Execute strSQL, dbFailOnError

http://lessthandot.com

 

[gwoman]

Thanks ... I'll try it!