Hi there! I have a form. (obviou

[katiekat]

Hi there!

I have a form. (obviously) I would like to have a field(s) that take the place of the reccord navigation. I know you can just leave the it on, but I would rather not. I have all the navigation buttons, but I need to know how to do the "Reccord x of y" calculations. I tried a dcount expression in the control source, and I can't seem to get that to work, but it's probably a syntax error on my part. Could I please get a general example? Thanks thanks and more thanks! Holy tek-tips batman!:-0

 

[LarryDeLaruelle]

Katie:

Put this in your form's On_Current event:

Set recClone = Me.RecordsetClone
recClone.Bookmark = Me.Bookmark

txtRec = recClone.AbsolutePosition + 1
txtTotal = recClone.RecordCount

recClone.Close

Substitute your control names for txtRec and txtTotal.

Larry De Laruelle
larry1de@yahoo.com

 

[katiekat]

Thanks Larry! Works like a charm! Huzzah! :-D Holy tek-tips batman!:-0