Child Table usage

[FBrnstrmr]

I now have a form onto which I enter a location and a date and associated
info which are then sent to a table for assimilated storage. However in
addition to this info. which is formed by use of various list and combo
boxes. There are separate records associated with the same location and date
which I can create on the same page using other lists. Would it be prudent to
use a child table for these other records otherwise I am duping the top part
of the page everytime. Any other ideas would be most helpful or even a point
in the correct direction to help me do what I hope is clear enough to
understand. Keep in mind I am working with what I believe to be possible not
what I know how to do. Thanks in advance,
-F

 

[FBrnstrmr]

Actually I mean should I use a sub-form imbedded in the form to populate a
child table? If I can figure that out?

 

[John W. Vinson]

Actually I mean should I use a sub-form imbedded in the form to populate a
child table?
YES.

If I can figure that out?

Build a form based on the parent table. Build another form based on the child
table (I'd suggest using Default View... Continuous Form and drag the controls
all up to the top of the page, then drag the form's bottom edge up to the
controls).

Then drag the child form onto the parent form. Access will make it into a
subform.

Pretty it up and you're done.

 

[FBrnstrmr]

OK John now I know you are trying to torture me. I'll be more comfortable
after I figure it out! I'll be back after I try to sort out what you are
saying. But it sounds like you mean if I can drag the child based form
completely onto the "mother" form that it will self imbed. Thanks very much!

 

[FBrnstrmr]

good start; I can't find default view..... continuous form.Which version is
it in or where do I find it in either vb6 or 2007, please?

 

[John W. Vinson]

good start; I can't find default view..... continuous form.Which version is
it in or where do I find it in either vb6 or 2007, please?

I don't have either program installed. I'd suggest you search Help for
"continuous form". That's not essential, actually; there are several ways to
create a subform. The Form Wizard Subform tool will create a datasheet subform
which will work adequately for your purposes - and you can change it later if
you wish.

 

[FBrnstrmr]

Thanks I will see what I can do, but up to now I was confident I could do
what I needed. This is bit past my comprehension. Maybe I just need some
sleep.
I will advise as to my success.