Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record navigation bars generated by Form WIzard 1

Status
Not open for further replies.

NVF

IS-IT--Management
Aug 2, 2008
5
In regard to a record navigation bars that's generated by a Form Wizard, is it possible to programatically see the current record number? E.g., if the navigatin bar is showing "4", how can I programtically get that value? Similar question: Is is possible to programatically get the "last record number" associated with the same navigation bar. E.g., the form is showing record number "4" on the navigation bar but there are actually a total of 23 records that the user could see with the nav bar. When the form is showing record "4", how can I programatically get the value showing the total number of records associated with the navigation bar - which is this example would be 23?

Thanks for any suggestion.
 
Too easy mate.

something like this would work if put as the logic behind a button on a form...

Sub MyButton_OnClick()

Dim rs As Recordset

Set rs = Me.RecordsetClone

MsgBox (rs.RecordCount)
MsgBox (Me.CurrentRecord)

Set rs = Nothing

end sub
 

Hi NVF,

Sorry, bot I don't really understand your problem.
Is your form bounded?

because according to my knowledge, on a bound form, if you see in the navigation bar '4', then the data displayed on the form are from the fourth recird.
And, at the right side of the navigation bar, is always displayed the number of the total records.

Ja
 
Problem solved. Thank you all for you time and help.

NVF

Matthew 16:16
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top