Unbound forms are not less complex, but MORE. Having to set recordsources on
the fly is something you should avoid. Bind the forms to a table or query
then when you upgrade the sql it will be easy to set the links. Google unc
paths to find out how.
--
Milton Purdy
ACCESS
State of Arkansas


"icccapital" wrote:

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.