1. Two handy properties of the record set are BOF (beginning of file) and EOF (end of file). The BOF property is automatically set to true when the record pointer is before the first record in the record set.
The fastest way to search for a particular record is to use the Seek method , which can be used only with a table recordset tab.The Seek method uses indexes for the search , which is much faster than checking every record in the table as you do in a find .
1. When you want to add new record you have couple of choices. If you are using data control?s navigation buttons, you can allow Visual Basic to do the adds automatically. Set the data control?s EOF action property to
1. You can bound data to data bound controls like Labels, Text Boxes, Checkbox. If you don?t want user to change the data you use Label control, where user can only view the data else you can use Text boxes.
When you want to make sure that a required field has an entry or that field has valid data, the Validate event is good location to check. If the field is not valid, you can display an error message and cancel the operation.