Split form with more than one table/query (1 Viewer)

killerflappy

Registered User.
Local time
Today, 16:39
Joined
Aug 23, 2017
Messages
50
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

Well-known member
Local time
Today, 11:39
Joined
Apr 9, 2015
Messages
4,339
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

I’m here to help
Staff member
Local time
Today, 08:39
Joined
Oct 29, 2018
Messages
21,358
Hi. Rather than a split form, try using a navigation form.
 

killerflappy

Registered User.
Local time
Today, 16:39
Joined
Aug 23, 2017
Messages
50
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

MVP / VIP
Local time
Today, 15:39
Joined
Jan 14, 2017
Messages
18,186
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
 

Users who are viewing this thread

Top Bottom