Platform is Access 2003(XP), I have used MSAccess since 1995 (just so you know my level to understand your instructions.
I have a reservation system that uses a subform to assign the facilities needed for an event.  Some clients use the same facility for the entire year for the same day every month - ie second Tuesday every month.  I would like the code to fillin the dates for the rest of the year (or an stop date I specify) and repeat the facility code for every line in the subform for that eventID.  Have you created or seen VB code that addresses this and can be used in MSAccess?

---

Answer from Richard Rost:

You could do this with a little bit of VBA code. Just make a button in the footer of your subform that would do something like this: (THIS IS NOT TESTED, but is to just give you an idea of how to do it)

StartD = InputBox ("StartDate")
EndD = InputBox ("EndDate")

X = StartD
While X < EndD
  Docmd.GotoControl "DateField"
  Docmd.GotoRecord acNewRec
  DateField = X
  X = X + 7
Wend

This will basically form a loop that will run from your start date to your end date, going to a new record, and then setting the date. It will then move ahead a week (+7).

Again, I didn't test this, it's just off the top of my head… but it should get you started. I'm sure you'll have to adjust the field names and syntax a little bit.

Hope this helps.