How to insert Record # for Filter result in a Continous Form

[Fuard]

I want to put Record # in a Continous form. Also I have put filter so I need to show how many records filtered and the No. of the record.

[PEB]

Hi,
Please, Can you give us an exemple! I can't understand what just do you like to do?

Have a nice day!

:)

[Fuard]

Dear Mr. PEB

For example a candidate has multiple payments. If I select a candidate from a combo box it shows the particular payments in a continuous form so I need to put the Record # (No of payments 1, 2 , 3 ) .

Fuard

[PEB]

It isn't easy! With function your results wouldn't be good if you don't use append or make table query!

If you do a column specialized for this number - it's more simple! You can use a vb variable to store the last line number and increment the lines!

:)

[Fuard]

Sorry, I can't understand I am little poor in MS Access please if you can send some coding it is better

fuard

It isn't easy! With function your results wouldn't be good if you don't use append or make table query!

If you do a column specialized for this number - it's more simple! You can use a vb variable to store the last line number and increment the lines!

:)

[PEB]

Ok!

First create in your table the field line_n as number!

Insert it in your subform

Imagine that the foreign key for your table is MyFkey in MyTable

In Before Update event in your subform select event procedure!

Type the follow:

Me!line_n=nz(Dmax("line_n","MyTable","MyFkey=" & STR(Me!MyFkey))) + 1


:)

[Fuard]

Thanks I hope it will work

Regards

Ok!

First create in your table the field line_n as number!

Insert it in your subform

Imagine that the foreign key for your table is MyFkey in MyTable

In Before Update event in your subform select event procedure!

Type the follow:

Me!line_n=nz(Dmax("line_n","MyTable","MyFkey=" & STR(Me!MyFkey))) + 1


:)