Navigation question

[Sarah]

Hello
my form has a subform (single view) with the link field CustID. In the
form's footer I have a textbox with Control Source =Count([CustID]), that
works as expected (eg 126). What I would like to do is add another textbox
that shows which record is showing in the subform (eg 47). I'll arrange
these two textboxes to give me something like Record 47 of 126.

Because I'm trying to learn, I don't want to use the built in navigation
button.

 

[Mark A. Sam]

Hello Sarah,

You would refence like this:

=[mySubform].Form![CustId]

Where [mySubform] is the name of the subform control.

God Bless,

Mark A. Sam

 

[Sophie]

hi Sarah
try this, from Dev Ashish's Access web. It works great
www.mvps.org/access/forms/frm0026.htm