Here's our Microsoft Office Tip for.. May 12, 2003
Click Here to see a complete list of all of our previously released Tips!
Opening to a Specific Record
If you've ever wanted to open an Access database to a specific record at startup, then check this out. By default, a form displays the first record in the underlying recordset. Perhaps the easiest method is to use the GoToRecord method in the form's Open event. The GoToRecord method uses the syntax
DoCmd.GoToRecord acForm, "formname", acGoTo, recordnumber
where acGoTo is an intrinsic constant and recordnumber is the numeric value that equals the record you want to view--in other words, the record number.