Autopopulation of records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a master table which holds a record and a table bellow with can hold
muliple records based on this but with a different postion number.

Is it possible to auto populate a set number of records in the linked table
bellow
but keeping the postion numbers going from 1-n.
 
Possible, but why create records you may never use? Usually, you create
records as you need them.
However, it is possible using VBA to do that. Just create a recordset using
the table, and use a For Next Loop to write out as many new records as you
want. You can use the variable controling the Loop to populate the position
numbers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autopopulate 2
Access Dcount (multiple criteria) 3
Auto Fill Custom Number on New Record 2
Save record sequence number from form 2
New record problem in sub-form 5
Separate Form 0
Populate field from previous record 0
Update new record with previous record field 5

Back
Top