Form won't open

[buckwheat]

Can anyone tell me why I would suddenly get a message that there isn't enough memory to open a form? . . . this is happening when selecting a specific form (Physician Details).



This is an inherited database. There is a form (Search Options) that has at least a dozen cbo boxes and a "view" cmd button. when a cbo item is selected and cmd is clicked, it triggers the "Physician Details" form. The Physician Details form has several subforms and subforms with subforms. The Physician Details source is a very large query that references all of the cbo boxes in their respective query fields for all subforms e.g., "form!SearchOption!address . . . etc.

This particular database all of sudden has stopped performing properly . . . it did have over 200 macros that triggered each and every cmd button that were converted to VBA manually. Is it possible that there is a corruption issue?

[June7]

Certainly possible. Have you run Compact & Repair? Is this a split design? Have you tried different computer?

[buckwheat]

Is not a split. I copied and pasted it from my personal drive to the network and it opened, so ugh figure that one out.

Next crazieness is when I select from the cbo box on the Search Option form, and the Physician forms opens, it is in design view, I am trying to access the "+" but am just getting the query references to each, e.g., form!SearchOption!address. I think I mentioned this problem yesterday.

[June7]

Don't know why it would open in design view. The form is supposed to open in Datasheet? Will have to review code and maybe the form design.

[buckwheat]

one of the subforms is datasheet . . .it's really confusing how it is set up, I'll plug away and visit forum again if I can't resolve.