Solved Form-Subform: how can I add a non-filtered tabular view of the data? (1 Viewer)

Etxezarreta

Member
Local time
Today, 07:28
Joined
Apr 13, 2020
Messages
175
Hello everybody,

I have a classic Form sub form view: in the following picture, the first red framework is the mainform, polulated from table1, the green framework is the subform populated from table2.
The Father-son fields are Id_Code in table1, and Fk_Code in table2.
Now, I would like to add a third subform, underneath the red one: it is a tablular view of the data from table1, but it shouldnt be filtered when I select a data in the first red framework, the selector should point out the selected record.
Thank you in advance for your suggestions.
Etxe.


1603785689232.png
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:28
Joined
May 7, 2009
Messages
19,169
just drag the new subform to the Main form.
remove the Link Master/Child Fields on the subform if
automatically inserted.
 

June7

AWF VIP
Local time
Yesterday, 22:28
Joined
Mar 9, 2014
Messages
5,424
Consider a Split form bound to table1 with a subform bound to table2 in the single record view section.
 

Etxezarreta

Member
Local time
Today, 07:28
Joined
Apr 13, 2020
Messages
175
Hello Arnelgp,
I have tried this way, but the selector wouldnt appear and point to the record.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:28
Joined
May 7, 2009
Messages
19,169
you will only see the selector (black backround) when the subform has focus.
you can manully select the new subform on the Main Form's Load event;

private sub form_load()
me!subformName.setfocus
end sub
 

Users who are viewing this thread

Top Bottom