dynamic form creation (1 Viewer)

[shrndegruv]

This is sort of a continuation of my dynamic row post -- basically I have apartment units in one table with either 0, 1, or 2 bedroom table entries attached to each unit. (Meaning I have a Bedroom and Unit Tables, where multiple rows in Bedroom are related to one row in Unit).

The question is, how does one create a form from mulitple tables when you dont know how many rows in one table you will need to modify?

Do you need to write the form elements with VB?

 

[Pat Hartman]

When you want a form that works with both data from the 1-side table (apartment) and the many-side table (bedrooms), you would use a main form for the 1-side data and a subform for the many-side data. The many-side subform is usually either in continuous form or datasheet view so that multiple records can be seen at once.

If you look at any sample db that come with Access or any of the templates or almost any finished database, you will see examples of this type of form.

No code is required.