As for question 3

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?

You can build code to move next or move previous based on the combobox you are
using to get the record. You just need to know which record you are on and
where that is in the combobox. Then get the value of the previous/next row in
the combobox, set the combobox to that row and execute the code to select the
record based on that value.

If you need help building that code, post back. If I have some free time
later today, I will try to help.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County