Fazolator
Last Activity: Mar 11 '21, 08:12 PM
Joined: Mar 10 '21
Location:
-
Fazolator replied to Link two subforms (datasheet view and form view) to the same record in the main formin AccessNeoPa, well, it turns out that Access suppresses the display of the form header, too. It's frustrating. -
Fazolator replied to Link two subforms (datasheet view and form view) to the same record in the main formin Accessisladogs, thanks for the reply. I like your emulated split form and no doubt will use it in the future. I'm going to try NeoPa's solution first as it will not require as much recoding. If that does not work, I'll check out your emulated subform solution. Again, thanks!Leave a comment:
-
Fazolator replied to Link two subforms (datasheet view and form view) to the same record in the main formin AccessNeoPa, Thanks for the insights! My issues aren't with the linkings, but with the display. If an Access subform could be displayed in split-form mode I would have been done days ago :-).
That said, I'm going to try your idea for the main form on the sub-form instead... that is, display the subform as a continuous datasheet and put the displayed fields in the subform's header.
BTW, the reason for the rather tortuous display is simple:...Leave a comment:
-
Fazolator started a topic Link two subforms (datasheet view and form view) to the same record in the main formin AccessLink two subforms (datasheet view and form view) to the same record in the main form
For starters, I'm not asking the usual question about how to link the records in a subform to the main form. I know how to do that by linking Master and Child fields. The problem I'm trying to solve is that Access won't allow split form view on a sub-form.
A scenario: Assume there are two tables, like this:
Table1 - Invoices
InvoiceNumber as String
Lots of other fields
Table2 - InvoiceLineItem s...
No activity results to display
Leave a comment: