Record Number

[DBFIN]

Form 1 has a textbox called Recno with datasource = [Current Record]. When I use the navigation bar to move from record 1 to record 2, Recno should automatically change from 1 to 2, but it does not.

Why doesn't the Recno textbox update automatically ?

 

[rzw0wr]

Try me.refresh. Or a little more information. Dale

 

[missinglinq]

Why doesn't the Recno textbox update automatically?

Because you have a Space between Current and Record:

=[Current Record]

needs to be

=[CurrentRecord]

Sometimes it also helps to force Access to load the entire RecordSource on opening the Form, using

Private Sub Form_Load()
  DoCmd.GoToRecord , , acLast
  DoCmd.GoToRecord , , acFirst
End Sub

Linq ;0)>