Auto Line Number Continuous form

[barkly]

Seek help please. How do I put auto generated line numbers on a continuous form?



I note this very simple method for Reports -

Control Source =1
Running Sum Over All

I cannot find anything like this for a form ie what detail to I put in the designated TextBox.

Thanks

barkly

[ItsMe]

Unbound controls do not play well with continuous forms. The title of your thread suggests you want the record number. THis would need an unbound control displayed in each record and it will not disp[lay information correctly.

You can access the record number property something like this.

Dim lngAbsoulute As Long
lngAbsoulute = Me.Recordset.AbsolutePosition

If you want to do a sum calculation like your code suggests, you might try an unbound control in a header or footer.

[June7]

Review

http://www.lebans.com/rownumber.htm

http://allenbrowne.com/ranking.html

But really, what purpose does this serve?

[ItsMe]

There you go, have it available in the recordset via the query.

[barkly]

Thanks all for your interest and responses. You will see from the Allen Browne version that is where got the method for a Report - unsuitable for a form of course.
I shall look at each of the suggestions but i think I am now leaning to perform a simple count process back at the query behind the form and let the form take the values.

[azhar2006]

Hello
So after my instructors
Try this code
Put a text box on the form (intBCUIRNum)
Put this code in when loading
If Me.NewRecord Then
On Error Resume Next 'It should never occur, just to be sure...
Me!intBCUIRNum.DefaultValue = Nz(DMax("[intBCUIRNum]", "tblName"), 0) + 1
End If

[barkly]

Thanks Competent Performer,

I do not understand this part Nz(DMax("[intBCUIRNum]", "tblName"), 0) in particular tblname. My form derives its data from a query and within this query I do not have any reference to intBCUIRNum.

I should advise I am at the hacker end of the spectrum when it comes to Access - I have to plug away at it.

Thanks for your interest

[azhar2006]

Hi barkiy
Must be (intBCUIRNum) field within the table
And then summoned to the query

[barkly]

Apologies azhar2006 ( yes I do agree a-Competent Performer),

Yes I have it now as you advised but still no number display unfortunately.

I presume by your previous statement

Put this code in when loading

you mean at the Form an Event Procedure under 'On Load'.

This is what I have but as I say -no numbers.

Thanks again

barkly

[azhar2006]

See The DB