MS Access: Bound continuous form display multiple records with a sub-form also displaying multiple records?

Question

In MS Access is it possible to create a bound continuous form displaying multiple records along with a bound child/sub-form which is also displaying multiple records.

Both forms are linked together through relationship. I have made a form but the main form is only displaying one record at a time even though it is set to continuous!

I am using Access 2003.

Answer 1

No, it's not possible.



You can't view a form as continuous if it contains a subform. The reason is that the subform relates to a single record on the parent form, so the parent form can only display a single record at a time.

Answer 2

Access Continuous Form

Answer 3

Are you certain it is multiple forms, or multiple records being displayed on one form? It sounds as if you have set the Forms default view property to Continuous Forms. Instead, set your sub-data form's default view property to datasheet or single form. Single Form will display one record at a time, while datasheet will display it as though you were looking at the table.

Answer 4

Yes you can, but make sure you have set your relationships first.

This makes life easier, especially when modelling many to many subform relationships.





MS Access ebooks

http://access-databases.com/products.php

Answer 5

it is not possible, master form has to display one record.



regards

iLoveCoding

http://iLoveCoding.co.uk