Hi, I have an app with nested sub-forms, record navigation is confusing and I've started turning on record navigation controls.
To fix this, I am stuck at the 'n of n' field at the top of the form, whether a general property ( S) / query which will give me this?
For the first n, use the full property of the records cloned form.
For the second, use the RecordCount property.
Update : I like the approach of Mike through the current record. I have created a form with 2 text boxes: txtCurrentRecord and txtRecordCount Again, for the current event on the form, this process makes the text box to display the same values as a built-in navigation bar.
Private Sub Form_Current () Me.txtCurrentRecord = Me.CurrentRecord if not Me.NewRecord Then Me.txtRecordCount = Me.RecordsetClone.RecordCount Else Me.txtRecordCount = Me.CurrentRecord End if End Sub < / Code>
Update2 : I added a process to make sure that RecordCount is accurate.
Private sub form_load () Me.RecordsetClone.MoveLast Me.RecordsetClone.MoveFirst End Sub
Comments
Post a Comment