Hello, Just want to ask, if there is a way to have 3 split forms separated by tabs in 1 main form?
D dhen21dx New member Local time Tomorrow, 05:35 Joined Aug 28, 2013 Messages 5 Jun 12, 2019 #1 Hello, Just want to ask, if there is a way to have 3 split forms separated by tabs in 1 main form?
Minty AWF VIP Local time Today, 22:35 Joined Jul 26, 2013 Messages 10,371 Jun 12, 2019 #2 Not sure I get your question clearly, can you mock up a picture? Split forms are notoriously fussy to work with and difficult to program events on correctly, you may be better with an alternative design.
Not sure I get your question clearly, can you mock up a picture? Split forms are notoriously fussy to work with and difficult to program events on correctly, you may be better with an alternative design.
D dhen21dx New member Local time Tomorrow, 05:35 Joined Aug 28, 2013 Messages 5 Jun 12, 2019 #3 My design is like i want 3 tabs, and per tab i have data sheets and filter function to search for the data records.
My design is like i want 3 tabs, and per tab i have data sheets and filter function to search for the data records.
Minty AWF VIP Local time Today, 22:35 Joined Jul 26, 2013 Messages 10,371 Jun 12, 2019 #4 That is certainly possible, and doesn't sound like a split form, more like different datasheet sub-forms embedded on a main form.
That is certainly possible, and doesn't sound like a split form, more like different datasheet sub-forms embedded on a main form.
D dhen21dx New member Local time Tomorrow, 05:35 Joined Aug 28, 2013 Messages 5 Jun 12, 2019 #5 Can you give me an idea, how will to do it?, i can be done via macro "Apply filter as well"? or do i need vba?
Can you give me an idea, how will to do it?, i can be done via macro "Apply filter as well"? or do i need vba?
June7 AWF VIP Local time Today, 13:35 Joined Mar 9, 2014 Messages 5,470 Jun 12, 2019 #6 By 'data sheets' do you mean forms in Datasheet view? You want different datasource on each tab? Filtering can be done with macro, VBA, or right click menu. As far as I can tell, intrinsic Split form cannot be a subform.
By 'data sheets' do you mean forms in Datasheet view? You want different datasource on each tab? Filtering can be done with macro, VBA, or right click menu. As far as I can tell, intrinsic Split form cannot be a subform.
theDBguy I’m here to help Staff member Local time Today, 14:35 Joined Oct 29, 2018 Messages 21,467 Jun 12, 2019 #7 Hi. As June said, split forms can’t be used as subforms, so you will have to simulate them instead.