Good morning and thank you for letting me join your forum.
I'm reasonably new to Access so will try to offer advice if I can.
I am looking for a bit of advice at the moment though.
I have created a form that has numerous pieces of information that is needed to form a record, this can potentially exceed 255 items, maybe I'm doing something the long way and someone could point me in the right direction.
My form is an invoice form that contains numerous items to be invoiced. I can generate client addresses easily enough with site detail etc but when it comes to entering the detail the same detail is entered again and again for example
Item
Description
Cost
VAT
Total
At present each line and entry is represented by a separate column so each line will contain 5+ columns extra in the table.
At the moment the form can handle 13 lines but it needs to the have another page generated for the additional lines (advice also needed on this)
as you can appreciate after so many lines the table can soon exceed the 255 column limit.
Thanks in advance
Edd