Navigation buttons on an unbound form

[Katy44]

I have a recordset which is filled iin my VBA by running a SQL Server stored procedure.
I am then trying to display the returned records on a form. I have put navigation buttons at the bottom, and I want to display one record per 'page' i.e. navigate through the records using the buttons. I just can't get this to work!!
I fill the recordset, and then fill each field on my form with a field from the recordset:

With Form_MyForm
.Field1 = rs("Field1")
.Field2 = rs("Field2")
...etc

What else needs to be done to make the navigation buttons scroll through all the records in the returned recordset? At the moment, it seems to just display the first one, which looks fine, but the nav buttons are greyed out.

 

[Katy44]

This was caused by a few properties of the recordset that weren't correct (the defaults needed to be changed)
I'll post the exact details on Monday.

 

[Katy44]

The syntax was:

rs.CursorLocation = adUseClient
    
rs.Open sqlCmd2, , adOpenKeyset, adLockOptimistic

(rs is an ADODB recordset)