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.