multiple column forms (1 Viewer)

JimL

Registered User.
Local time
Today, 14:34
Joined
Jul 9, 2019
Messages
20
Good day to you all!

I have a query that generates 50 records summarizing the count of observations per center. I want to display all the results on one form page, splitting the results into 2 columns.

Is there a way to do so? I can set the query to display the top 25 records, but don't know how to display the bottom 25.

As always, replies are most gratefully appreciated.

Regards

JimL
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:34
Joined
Oct 29, 2018
Messages
21,358
Hi JimL. Would you need to edit the data on the form or is it just for display purposes only?
 

JimL

Registered User.
Local time
Today, 14:34
Joined
Jul 9, 2019
Messages
20
No, just to display.

Thanks

Jim
 

theDBguy

I’m here to help
Staff member
Local time
Today, 11:34
Joined
Oct 29, 2018
Messages
21,358
No, just to display.

Thanks

Jim
If that's the case, I would suggest using a multi-column report instead of a form. I am not sure if you can embed a multi-column report in a form, but you might give it a try, if you need to add some functionalities, which are only available when using a form. Good luck!
 

JimL

Registered User.
Local time
Today, 14:34
Joined
Jul 9, 2019
Messages
20
Not to seem obtuse, but how do I create a multi-column report?
 

isladogs

MVP / VIP
Local time
Today, 18:34
Joined
Jan 14, 2017
Messages
18,186
The other method that will definitely work is to split the list into two.
1. SELECT TOP 25 …. Call that qryTop25
2. Create an unmatched query using the wizard joining the original table and qryTop25. Any unmatched records are the bottom 25.

Now use a form and subform side by side to show the records in the two queries.

Hope that helps
 

JimL

Registered User.
Local time
Today, 14:34
Joined
Jul 9, 2019
Messages
20
Thank you.

This solution works wonderfully.

The singular issue I have is that on both subforms, the first record has what appear to be navigation icons (up and down arrows). Is there a property that I can change to get rid of it? Since the arrows don't do anything, they are nothing more than a distraction for the user.

Again, I appreciate the time and the response you provided.

JimL
 

isladogs

MVP / VIP
Local time
Today, 18:34
Joined
Jan 14, 2017
Messages
18,186
Which solution did you use?

If you mean the tiny arrows in the field headings in datasheet view, these are used to sort the data by the selected field either ascending or descending order.
If you don't want that feature, go to the property sheet for the form in design view and set the Shortcut Menu property to No.
If not, please show a screenshot of the issue you are referring to
 
Last edited:

JimL

Registered User.
Local time
Today, 14:34
Joined
Jul 9, 2019
Messages
20
Thank you once again. It worked as advertised.

Have a great week!

JimL
 

isladogs

MVP / VIP
Local time
Today, 18:34
Joined
Jan 14, 2017
Messages
18,186
Excellent. Both DBG and I were glad to help.
 

Users who are viewing this thread

Top Bottom