I'm not sure if you can change the recordsource of a form that currently
has the focus. I will be in a mainform where I can change the
recordsoure of a subform. The big thing is to remember to reset the
control source for each textbox in the subform (or mainform if it is
possible to change the recordsource from within the mainform). When you
change the recordsource - you have to re-point each textbox to the
desired control source.
Rich
*** Sent via Developersdex http://www.developersdex.com ***