troubleshooting Question

MS Access Form display 2 field table in multiple columns

Avatar of Clay Willing
Clay WillingFlag for United Arab Emirates asked on
Microsoft AccessMicrosoft Applications
9 Comments1 Solution522 ViewsLast Modified:
Hi Experts All,

I have rather strange request for help regarding a form layout or formatting option.  I have a table with a max of 30 items (I would hope) that has a few related fields.  The form I would like to display this on I want to be wide rather than tall so I want to split the table into 9 columns rather than 3 tall ones.

I have a solution where i count the number of entries in the table and set the control source of a subform to "SELECT * FROM tblCritical WHERE [critID]<= 8 " then a second subform with "SELECT * FROM tblCritical WHERE [critID] >8 and [critID]<=16 " etc but is there a better way of doing so? However, this early on in the development of the form I havent taken into account what happens if the SQL causes and error or anything like that.

Any assistance greatly appreciated.
Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros