Saving an Access for with Subforms as a Data Access Page?

[danny2000]

Hi

I know how to save an access userform as a Data Access Page though can't seem to save it when it has Subforms on it (in one piece). The main form saves as a Data Access Page separately?

Would anybody know how to save an access userform displaying linked tables via the use of subforms as a Data Access page so that the form and all the subforms are displayed on that page?


Any advice on this at all would be well appreciated.

Thanks in Advance
Danny2000

[danny2000]

I'll answer my own question as I've since been able to obtain an answer.

You cannot save a Userform with Subforms and maintain them in a Data Access page. Access will only let you save simple forms as Data Access pages.

Thanks for looking anyway.

Danny2000