I am having problems writing a simple Macro to close a form and then open another form. What appears to be happening is that related tables/queries are not closing and so the 2nd form cannot open, producing a error message:
"The Table 'LAs' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically"

How can I ensure that when a form is shut all related tables/queries get shut, or how can I allow tables to be opened by multiple forms simultaneously?
Cheers,
Tim

Have you tried an event procedure on your form's LostFocus property, i.e. DoCmd.Close ?