I'm working on implementing John Spencer's description of a parent form that
has only one record open at a time, and three questions occur to me:

1. Do you use DoCmd.OpenForm stDocName, , , stLinkCriteria in the
AfterUpdate event of a combo box to move between records?

2. You would be using a SQL SELECT statement to populate the combo box used
to navigate between records once the form is open, but how do you determine
which record to open when you initially load the form? That is, how do you
extract the value of the first record (or for that matter, any record) in
that SQL statement to use as the stLinkCriteria when you first open the
form?

3. Since the main form has only one record loaded at any time, the normal
navigation buttons won't be able to do anything. Are there any Web sites
that address building custom navigation buttons for single-record forms?

Thanks in advance,

Paul