tab control subform

[chriske911]

I want to use a tabcontrol where I show a number of records filtered
per tab page

it is meant to be a nicer looking alternative to the plain subform
showing records filtered according to the record shown in the parent
form
since I have few parent records I can get away with the number of tab
pages required

what would be the nicest and most performant way to do this at the same
time?

thnx

 

[Arvin Meyer MVP]

If you do this you won't be able to enter or edit your data since 2 or more
different forms will be locking the table. By click on a scroll bar, the
next group of records are always displayed. How is that different from
clicking on a tab?

 

[chriske911]

If you do this you won't be able to enter or edit your data since 2 or more
different forms will be locking the table. By click on a scroll bar, the next
group of records are always displayed. How is that different from clicking on
a tab?
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I don't want a recordset per tab page but just show a filtered set of
records per tab page,
you can only see 1 tab at the same time anyway

the main form would retrieve the full recordset anyway

I know it sounds odd but it seemed a nice idea from a designer point of
view,

now it is up to me to create it

grtz