Can't save after resizing/moving about form fields - MS 2007

K

Karen

I have a form that is filtering the information from a table (i.e., there's a
criteria in the data property/filter field on the form). I can resize the
form fields and move them about in design view but I cannot save the changes.
Each time I "X"
out of the form, I'm prompted to save. I click Yes, then click "X" but it
doesn't close the form or Access.

Are there criteria in the form that could be preventing the acceptance of
the changes to the form?

Appreciation in advance, for all help.
 
K

Karen

"Has Module" property was set to yes. I changed it to no and allowed all
views except form view and it allowed me to save the changes.

I still have the original form, however. How can I check what module is
attached to this form and whether it is necessary/useful? I'm not too
certain what a module is and what it may do actually.
 
K

Klatuu

A form module is where any VBA code used by the form kept. It is considered
a Class module because it relates strictly to th form. Whenever you use any
VBA for a form's events, it is in the module.

The code in the form's module can call procedures in other modules.

A form does not require a module, but if you do not have a module, then all
event actions have to be done with macros and expressions.
 
K

Karen

Seems like I have a class module on this form but how can I know that for
certain? I.e., how can I check to be certain there is such a code and what it
is? It is quite possible that "Yes" was entered for a reason b/c there is
truly code behind there but I don't want to delete it without knowing the
implications.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top