Creating multiple text boxes...

G

Guest

In a subform, how do you create a multi box imput field? i.e. -
Date Notes
By this I want to be able to have multiple lines that can be added in this
subform with different dates? i.e. -
9/25/2006 Notes Test One

9/26/2006 Notes Test Two

This are on the Table and I want to have the table and the form to show and
record the multiple entries??
 
G

Guest

Yes sir,

After messing with it more, I actually figured out what I needed to do. In
the subform, properties I need to change the default value to continuous
forms. I should have just thought about it more. Thank you for the
response.
 
M

Marshall Barton

Transfer said:
In a subform, how do you create a multi box imput field? i.e. -
Date Notes
By this I want to be able to have multiple lines that can be added in this
subform with different dates? i.e. -
9/25/2006 Notes Test One

9/26/2006 Notes Test Two

This are on the Table and I want to have the table and the form to show and
record the multiple entries??


If there can be many "dates" and/or "tests" for a single
"main" item, then you should have the "many" data in a
separate table that uses a foreign key to link to the
corresponding records in the main table.

Once you have a normalized table structure, the subform is
straightforward. Any view of the data would work, but if
you want to see several records in the screen, use the
continuous (or datasheet, yuck) view.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top