I have a form that has a recordsource based on a query I typed in and I have
all the controls on the form unbound. I believe with a bound control it
keeps a link to the database so there is a lot of communication between form
and database right? With an unbound form does the recordsource "download" a
recordset that the form then walks through? So if I add a next button to the
form, when next is clicked does the form requery the database or does it get
the data from the recordset?

I am working in access 2007 and right now the database is split with the
backend still in access, but I hope to move it to sql server so that is part
of the reason I am trying to unbind some of the information, to improve
performance after the move.

Thanks for the thoughts.