Replace Navigation Button info on subform 2

[netrusher]

I currently have a subform that populates from an AfterUpdate
Event on the MainForm. The controls on the SubForm actually
get the information from a query. Once a PartNumber is
selected from a ComboBox on the Mainform a query is ran
with the PartNumber used as the criteria of the query. This
works well. On the Subform I have turned off the Navigation
Buttons and have inserted command buttons to move from
record to record. My question is this. When the Navigation
Buttons are not turned off it allows the Navigation from
record to record but it also says Record 1 of 4.
Since I have the Navigation Buttons turned off (this is
necessary), is there a way for me to show Record 1 of 4
or whatever the number is another way and keep the
command buttons?

 

[PHV]

Put a label in the footer section of the subform and then, in the Current event procedure of the subform:
yourLabel.Caption = Me.Recordset.AbsolutePosition + 1 & "/" & Me.Recordset.RecordCount

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[netrusher]

PHV that is AWESOME! Thanks for the help!