Is there a limit of the number of tables you and include on a form

[Neup44]

I have 5 tables with 31 items (some yes/no and text). When I add a 6th table with yes/no items and text, my form does not work.

Does this make senses? Is there a limit of the number of tables a form will populate?

Neup44

 

[PHV]

Your form is limited to a grantotal of 254 controls and sections.
Ask the help wizard for limitations


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Neup44]

Good Morning PHV,

When I asked the wizard for the "Form and report specifications" I did get a list of the specifications but I do not belive my database has reached the max. Any suggestions?

Neup44

 

[PHV]

Access keeps a history of all the controls (even the deleted ones) in the form.
You may try to Repair/compact your database in the hope of that will shrink this history list.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244