Unsolved problem: I have created a data entry form using a subform to allow multiple entries under one person's name|coordinates (address etc - on main form). However, whenever I enter a record, the underlying table always shows one additional record with just the the main form info (Name|coordinates etc and all the subform fields are blank - like the main form is saving a record before I get to the subform fields). Other than that additional entry, the rest of the records have all their fields correctly filled. Why is the mainform creating a record on its own without subform info? Have I linked my forms improperly?
Again: Form|Sub-form duplicate
- Thread starter SR
- Start date
Form|Sub-form on same underlying table?
(original thank-you below...sorry, more stupid questions...). I see in the example you sent me, that the underlying table for the mainform has the little column with the "+" you can press to see the related subform data. How do I create the table as such (I created the two tables and then created a related form and subform, but the underlying table does not show the "+" column)??
HUGE thank-you for the response MStef - the example was helpful
! I will start again with 2 tables instead of one.....(I had thought i wanted to have all the info on one underlying table for viewing and printing purposes, but, I guess its not necessary). Thank-you!
SR
(original thank-you below...sorry, more stupid questions...). I see in the example you sent me, that the underlying table for the mainform has the little column with the "+" you can press to see the related subform data. How do I create the table as such (I created the two tables and then created a related form and subform, but the underlying table does not show the "+" column)??
HUGE thank-you for the response MStef - the example was helpful
! I will start again with 2 tables instead of one.....(I had thought i wanted to have all the info on one underlying table for viewing and printing purposes, but, I guess its not necessary). Thank-you!SR
Last edited:
Missing subform data in datasheet view
Thank-you AGAIN! Defining the relationships fixed my problem, but, another one has arisen: when I try to display my form in datasheet view, the "+" (which displays the subform fields) does not show the data entered (the fields are empty). The underlying table(s) is recording everything correctly, but viewing in datasheet view shows empty fields (only the linked child field is filled, and the rest are blank).
????
Thank-you AGAIN! Defining the relationships fixed my problem, but, another one has arisen: when I try to display my form in datasheet view, the "+" (which displays the subform fields) does not show the data entered (the fields are empty). The underlying table(s) is recording everything correctly, but viewing in datasheet view shows empty fields (only the linked child field is filled, and the rest are blank).
???? MStef said:
