Avatar

Level 10

Stefan's code is very useful when you want to display a single record. Typically I woudl enter a value on a field and use that entered value as part of teh record search in my SQL statement (usually with a delayed open of the DB). If you want to get a subset of records and simply navigate through them that code is not neccessary. You can change the settings when you set up the dataconnection to enter a SQL command and enter it in the 1st panel. Then when the connection is made that SQL statement will run each time.

Capture.GIF