Populate field with incrementing number

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

Guest

From the main form, how can I populate a field in a subform with an
incrementing number (first record = 1, second record = 2, etc.)

Thanks very much in advance.
 
Angus -
Put an autonumber field in your subform table; in the data type area of the
table.
hope this helps.
Lisa
 
Thanks both of you for your replies but neither solution will work.

I cannot use autonumber as I do not want to populate this field in all
record this way. Most records will have non-sequential numbers.

I cannot use the solution in Alex's link as each number must be unique and
that solution would result in duplicate records when run on a different set
of records.

The solution will, I presume, involve a dynamic recordset and a loop until.

Can't work out the syntax though.

All help still greatfully received.
 
If your subform records all belong to one recordset and you want that
recordset to have a unique sequence number there are several possible
solutions. If you google groups on "custom autonumber MVP" you will find
several to choose from.
 

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

Populate subform field on Afterupdate of main form field 6
Form Save 4
need help on sequence number between related form and subform 3
Incrementing Values based on value of another field 1
Finding numbers not in sequence 3
Auto Increment recordset 4
More than one Table 3
auto-populate multiple records in a sub form 3

Back
Top