VBA, Record number display on Forms

Record number display on Forms

Author	Message
Matt Klosterma #1 / 2	Record number display on Forms I am trying to require that my users to use a "New Record" button on a form that validates the data before adding a record (usin a macro.) In doing this I have hidden the record navigation buttons for the form. This, of course also hides the current record number and the number of records in the table. Is there a way, either in the "More Controls" section or via VBA to display the current record number and total number of reords on the form?
Tue, 13 Dec 2005 23:35:48 GMT

Juan M. Afan de Riber #2 / 2	Record number display on Forms You can use a textbox and in its ControlSource property write =[CurrentRecord] & " of " & [RecordsetClone].[RecordCount] -- Saludos desde Barcelona Juan M. Afan de Ribera MVP [Ms Access] Quote: > I am trying to require that my users to use a "New > Record" button on a form that validates the data before > adding a record (usin a macro.) In doing this I have > hidden the record navigation buttons for the form. This, > of course also hides the current record number and the > number of records in the table. > Is there a way, either in the "More Controls" section or > via VBA to display the current record number and total > number of reords on the form?
Wed, 14 Dec 2005 02:11:39 GMT

Page 1 of 1

[ 2 post ]