Multiple record submission

[akshayyy]

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

 

[Travis]

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)