Line/Row Count on Subform

D

Dickie

I have a main entry form and a embedded subform. The subform is used to
enter line details for the header.

What is the best way of creating an automatic line number. The Autonumber
doesn't work because it keeps counting from Start of File. I want the line
count to be refreshed for every open form.

Example.

MainForm Number - 9000
Subform LineNumber - 001
002
003

MainForm Number - 9001
Subform LineNumber - 001
002
003
004
Etc....

Thanx
 

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

need help with NewRecord expression 1
tabcontrol page caption 1
assign number to new record 1
Cross-tab query - dynamic row headings for subform 1
Line Numbers On Subform 3
Show Record on subform based on current subform Line ID 1
Disabling a subform. 8
Line Items for Invoices 1

Top