Split form as a subform

[Ant_Snell]

I am trying to create a Split Form (all fields at top of screen with a data sheet view list of filtered records at the bottom) so that if you search for some criteria and you get say 25 results, you can see then all rather than just 1 of 25 you would see in a single form. You then can select the desired record from the datasheet view and the top 1/2 of the screen would reflect that record. This works fine if I change the default view of a single form to Split Form. However, my issue is that I want the whole lot as a subforum inside a master form. If I then drag the split form into the master form, I no longer can see the datasheet part of it. And if I make it a single form with a datasheet subforum both based on the same query, the datasheet subforum only shows the selected record in single form (not the 25 records that are the result of the search) If I run the source query on its own, I see all 25 results. I have tried Requiring both the form and subforum after update of the search button but that doesn’t seem to work.



Any ideas on how to get the split form to work as a sub form? Thanks

[CJ_London]

the datasheet subforum only shows the selected record in single form

remove the linkchild and linkmaster properties of the subform control

The subform will need some code in the current event - something like

Parent.filter="PK= " & Me.PK
parent.filteron=true

[Ant_Snell]

Thats done it Thanks