Originally Posted by
Cosmo Monkey
...MS Access 2010 says you can't embed a continous form as a sub form...
If you go back and check you will find that you have gotten the error message backwards! The actual message is
"A Form with a Subform Object can’t have its Default View Property set to Continuous Forms."
You cannot place a Subform on a Continuous Form; but a Continuous Form most certainly can be used as a Subform!
Originally Posted by
Cosmo Monkey
...I have tried a query as the source of the subform and it shows all records until I embed it as a subform and then only shows one records...
The point of the Main Form/Subform scenario is to present a one-to-many relationship, between two Tables, with one Main Form Record having one or more related Records in the Subform. In addition to displaying a Main Form Record and its related Subform Records, the construct allows for the entering of data into two different Tables from a single Form, something that is generally impossible, when using a single Form based on a multi-table query.
As you move from Record-to-Record, on the Main Form, the Subform Records are updated to show only the Records that are related to the current Main Form Record.
BTW, there is a workaround that I can give you, if you're interested, for adding a Subform to a Continuous View Form.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007