Display current record on continuous form

[CALV]

Hi all,

As part of my ongoing project, I now have a form whos data source is a query which is a sort of lookup. The form is continuous, and all is working well, BUT, I'd like a txt box on each record displaying the curent record number, I searched high and low to try and find this, but to no avail can anyone help?

TIA

CALV

 

[yessir]

y

y not just display the nav bar?

 

[CALV]

Hi, and thanks for the quick reply,

I did display it but I'd also like it in the top right of the continuous form


CALV

 

[ghudson]

Check out the CurrentRecord Property in Help for a sample and the details. You will need to use an unbound text box to do what you want.

HTH

 

[CALV]

Thanks,

I read the help, and it gave me the snippet of code, but how do I implement that in my db? where do I call it from?

TIA

CALV

 

[WayneRyan]

CALV,

I'd guess that you would call it from the form's OnCurrent
event.

Wayne

 

[CALV]

Thanks,

I tried that but I get a 1 displayed in every one

Heres what I put

Private Sub Form_Current()
Dim frm As Form
Call CurrentFormRecord(Forms!frmview_only)
Debug.Print lngrecordnum
End Sub


Sub CurrentFormRecord(frm As Form)
Dim strtest As Long
strtest = frm.CurrentRecord
Text39.Value = strtest
End Sub

TIA

CALV