Generate multiple records using 1 record

[Krisse Arthur]

I have a form with a date range and check boxes
representing Monday through Sunday. The user fills in the
date range and checks off one or more of the check boxes.

How do I create multiple records, 1 for each date within
the date range that is one of the days of the week
indicated by the check boxes?

Thanks for any help you can give me!

 

[Thomas]

You'd have to do that using code and recordset:

dim rs as recordset
set rs = Currentdb().OpenRecordset("TableName")

rs.addnew
rs!Day = "Monday"
rs!SomeField = "1"
rs.update

rs.AddNew
rs!Day = "Wedensday"
rsSomeField = 4
rs.update

.....