Trouble showing main form and subform together.
Posted on 2006-03-31
Once I get this together, I'll be in pretty good shape...
I have a Main form called ORDERS and a subform called TIME.
In the ORDERSI have 2 date fields: txtStartDate and txt EndDate. IN the subform I have a date field and a few currency fields. The underlying query of the TIME subform. Has the following:
Between [Forms]![ORDERS]![txtstartdate] and [Forms]![ORDERS]![txtenddate]
This brings up all time spent in a table called time. Here's my main issue. This works fine and all but in only shows me subform results in the following way.
I want the main form in datasheet view and to show fields from the subform as if they were part of the main datasheet, not as a subdatasheet (So the user can see everything without having to hit the plus sign to see the other data