...
The code works as advertised, which is that the first matching record is displayed, unless no record is found in which case the Error function displays a message. Annoyingly (to me) the message is accompanied by the Windows critical error sound. I tried the Message() statement but that just puts a message in the status bar. I couldn't find a noise-less Error function.
Modifying records
Displaying a record is one thing - what about modifying it? Here's some button code that does just that:
...
ScreenToFile copies the screen variables to the file buffer.HModify updates the file. But there's still that combo box on the screen with a drop list of names. The ListDisplay function refreshes the combo box, retaining the current selection.
Navigation
Navigating through records is pretty straightforward. Here's the code for the First, Previous, Next and Last buttons:
...
The Info dialog uses a marginally less annoying sound than the Error dialog, but I still can't find a way to display a message without triggering a sound.
Queries
So far the tutorial has looked at record by record data retrieval. But there's another day to retrieve data, and that's by using a query.
...