Hello,


The question I have is that how do I make multiple record
submissions from ACCESS FORM OR a DATA ACCESS PAGE.
for example,
My form look like the following

Name _ _ _ _ _ Date _ _ _ _ _ _

Hours for last two weeks.

| Monday | Tuesday | Wednesday |Thursday | Friday
-------------------------------------------------------------
Week1 |________|_________|___________|_________|________ _

Week2 |________|_________|___________|_________|________ _



Each week is one resord and I want two record to be submitted
at the same time with a single BUTTON click.

any help will be greatly appreciated.

HAVE A MERRY X-MAS AND HAPPY HOLIDAYS .


Tikka

Use a loop procedure like this

For x = 1 to 2
stSQL = "Insert Into tblName (Week, Monday, Tuesday, Wednesday, Thursday, Friday ) Select Week" & x & ",MondayTime,TuesdayTime,WednesdayTime,ThursdayTime ,FridayTime"
Next x

This will run the Insert Query Twice changing the Week value each time (first time = Week1, second time = Week2)