adding navigation buttons to a form connected to a data source

[kylemgreen]

Fellow VB users and abusers

I'm playing around with connecting my program to database on a local server. Basically, I've created a form with three text boxes corresponding to three fields in a table in an MS Access database. The controls are bound through the Data Environment (DataEnvironment1). When executed, the first record is displayed in the text boxes, but when I click either of the two navigation buttons (Previous and Next) I get an error message stating that there is an unknown method "Recordset".

To move to the next record I've used the following code.

DataEnvironment1.Recordset.MoveNext

Why is Recordset not understood? Does this have anything to do with the version of MS Access I'm connecting to? Or is my code simply wrong?

Thanks
KG

[scoutt]

instead of having recordset, change it to rscolumnName, where colum name is the name of your column in your table.
then make sure you have

dim rsColumnName as Recordset

in the option explicit section.

Scoutt