Split form with more than one table/query

[killerflappy]

Hi guys.

In my WMS I want to add some checks for administration.

When the click a botton a popup form must be displayed.
The form have some buttons for actions and some to show tables/querys
This is the easy part.

What I don't know is how tot add more than one table/query in a split form.
What I like to see is that I can click buttons on the form to show different information in a table below these buttons.
Is this even possible?

 

[Ranman256]

You can combine tables into 1 query.

But users can't really absorb info by looking at a thousand different items shown at once.
Make 1 button to see 1 table/query (list or single record)
Add many buttons.

 

[theDBguy]

Hi. Rather than a split form, try using a navigation form.

 

[killerflappy]

Hi. Rather than a split form, try using a navigation form.

Thanks for the tip. Well that seems to easy!

Unfortunatally, this won't work for cross-table query's.
These query's are not shown correctly.

Any idea's how to handle this?
I thought about, putting the 2 crossquery's combined in a table. But then I can't refresh the table very easally in the navigation form.

 

[isladogs]

Both split forms and navigation forms have their uses but trying to modify their structure is problematic and best avoided.

Much better to use several subforms.
Consider using a tabbed main form with subforms on the various tabs.
There is no reason why crosstab queries shouldn't display correctly in a subform