mcarollo1
asked on
Variable Length SubForm
Is there a way to have a variable length subform append its records in multiple columns, rather than just vertically?
ASKER
The maximum number of records can be assumed. ex. I know there will never be more than 12.
This can be "tricked" in various ways. One would be to create twelve subforms and make them visible when there is data. Another way could be adding columns in a datasheet subform.
I'm just curious why you want to go horizontally iso "unlimited" vertically....
Nic;o)
I'm just curious why you want to go horizontally iso "unlimited" vertically....
Nic;o)
ASKER
can you expand on the 12 subforms idea?
For this easiest will be to have a sequence number (1-12) in the data. This will enable you to do a link between an unbound field per subform (filled with 1-12) on the main form and the datafield of the subform to have the data automatically in the correct subform.
If wanted you could make the empty subform(s) invisible, however that will take extra VBA coding.
Need more info ?
Nic;o)
If wanted you could make the empty subform(s) invisible, however that will take extra VBA coding.
Need more info ?
Nic;o)
ASKER
How is that done?
Can you drop the (compacted and zipped) .mdb in my nico5038 mailbox "at" yahoo.com.
The I'll make a sample.
Nic;o)
The I'll make a sample.
Nic;o)
ASKER
OK, I'm sending an example to your yahoo address
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very creative. Thanks for your help!
You're welcome, success with the application !
Nic;o)
Nic;o)
There might be a workaround if the maximum number of records is known. Let us know if that's the case.