Specifying Rows

[Chris]

hello all,

I have a form that asks how many children a person has (text box). I would
like the number of rows in a subform (linking to the children table) to
equal the number of rows specified by the user. e.g. 4 children would allow
4 rows for their ages.

Is this possible? and if so what is the best way of doing it?

 

[Rick B]

Just a side note...

Depending on what you are doing, you might ask for the birth date and
calculate ages instead. If this data will be stored and used later, what
happens when a birthday passes and the child ages.

If you are only using it for the current date, this may not be important to
you.

Just a thought.

Rick B


hello all,

I have a form that asks how many children a person has (text box). I would
like the number of rows in a subform (linking to the children table) to
equal the number of rows specified by the user. e.g. 4 children would allow
4 rows for their ages.

Is this possible? and if so what is the best way of doing it?

 

[PC Datasheet]

You need a form/subform where the main form is based on the Parents table and
the subform is based on the children table. Doing this, you won't need to ask
how many children if the children records have already been entered. You will
automatically get four rows if the parents have 4 children. You will also get a
new record row. You can remove that row by going to the subform's Data tab in
properties and setting AllowAdditions to No.