I have a subform, (Subform1) from which I open another form (Form1)
to a specific record, however, once I have opened Form1 I cannot
scroll through the various records as it remains locked on the record
to which it opens. I know this it obviously logical but is there a way
to scroll through the various records in Form1 once I have opened it?

TIA

On Mon, 26 Jan 2009 13:14:26 -0800 (PST), rwpearson (AT) clear (DOT) net.nz
wrote:

You're probably doing something like this:
DoCmd.OpenForm "Customers", , , "ID=1"

If so, this filters the form to the record with the given
where-clause. Simply clear the filter and the form will show all
records again.

-Tom.
Microsoft Access MVP