subforms

So I have a Main form with 2 subtables. I made a 1 to many relationship
between F1 and F2.....F1 and F3. F2 and F3 are linked to F1 parent/Child with
"ObID".



Now when I go to the Table for F1, the subtable "+" sign no longer works to
pull down the subtable.



I need to be able to add 2 or 3 or 4 additional items in F2 and F3 for the
same event in F1.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201002/1

On Tue, 02 Feb 2010 01:56:05 GMT, "thewabit via AccessMonster.com"
u57141@uwe wrote:

So I have a Main form with 2 subtables. I made a 1 to many relationship
between F1 and F2.....F1 and F3. F2 and F3 are linked to F1 parent/Child with
"ObID".



Now when I go to the Table for F1, the subtable "+" sign no longer works to
pull down the subtable.



I need to be able to add 2 or 3 or 4 additional items in F2 and F3 for the
same event in F1.

Um?

Do you have a *FORM* with *SUBFORMS* (which should be fine, and would allow
you to do this easily), or a *TABLE* with *SUBTABLES*?

If the latter, be aware that table datasheets are not well designed for data
entry or editing. They're very limited. For instance, I don't think you can
have two active subtables; whereas with a Form you could very easily (if at a
performance hit) have ten or more subforms.
--

John W. Vinson [MVP]

Yes...I have since learned that what I should have said was "subdatasheets".
I guess I was looking for 2 subdatasheets to drop down since I had two
different tables with a relationship with my main table. It looks like it can
only do one subdatasheet and they are not even recommended. I got the
subforms to work properly...

Thanks John.

John W. Vinson wrote:
So I have a Main form with 2 subtables. I made a 1 to many relationship
between F1 and F2.....F1 and F3. F2 and F3 are linked to F1 parent/Child with
[quoted text clipped - 5 lines]
I need to be able to add 2 or 3 or 4 additional items in F2 and F3 for the
same event in F1.

Um?

Do you have a *FORM* with *SUBFORMS* (which should be fine, and would allow
you to do this easily), or a *TABLE* with *SUBTABLES*?

If the latter, be aware that table datasheets are not well designed for data
entry or editing. They're very limited. For instance, I don't think you can
have two active subtables; whereas with a Form you could very easily (if at a
performance hit) have ten or more subforms.

--
Message posted via http://www.accessmonster.com