Generate multiple records using 1 record

  • Thread starter Thread starter Krisse Arthur
  • Start date Start date
K

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!
 
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

.....
 
Back
Top