Autofill Table from Hi/Lo Form values

[Forrest]

Help. I know just enough about Access to get myself into trouble.

What I want to do is have a form where I enter a low work order # and a high work order # with a series of yes/no questions and then have that autofill a table with work order #s incrementally from the low value to the high value and attach all of the yes/no answers to each work order #.

How do I get the table to autofill from low to high work order #?

Thanks for any help in advance and type slowly. I'm not very bright.

 

[Dennisk]

VBA code would do the trick.

Initialise a variable to your low value.

Loop from low to high

 

[Dennisk]

VBA code would do the trick.

Initialise a variable to your low value.
Loop from low to high number
and for each number either use DAO.ADO or SQL to insert the data one row at a time.