Disappearing Forms, Part II


R

Renee

I am having the same or similar problem as KW in this forum with disappearing
forms.
I created a form in Design View, but when I switched over to Form View, my
form was gone. All I had was the blue background color I selected for my
form. All the fields were missing. When I switch back to Design View, my
form returns.
 
Ad

Advertisements

D

Dirk Goldgar

Renee said:
I am having the same or similar problem as KW in this forum with
disappearing
forms.
I created a form in Design View, but when I switched over to Form View, my
form was gone. All I had was the blue background color I selected for my
form. All the fields were missing. When I switch back to Design View, my
form returns.
I haven't seen the original thread you refer to, but when you say the form
disappears, I get the impression that what you really mean is that the
controls (in the detail section) disappear. That will happen for any bound
form when its recordsource returns no records to be displayed and, for any
of several reasons, no records can be added. Among the reasons for a form
being unable to add records are: (1) the form's AllowAdditions property is
set to Yes, (2) the form was opened by code or a macro that specified that
it should be opened read-only, (3) the database itself is read-only, or (4)
the form's recordsource query is non-updatable.

You can check whether the recordsource query is updatable by opening the
query itself in datasheet view, and see if you can update or add records.
If not, you may be able to modify the query to make it updatable. There's a
help topic you should be able to find, "When can I update data from a
query?". One common issue: a totals query is never updatable.
 
Ad

Advertisements

D

Dirk Goldgar

Linq Adams via AccessMonster.com said:
Dirk had a typo here:

"Among the reasons for a form being unable to add records are:

(1) the form's AllowAdditions property is set to Yes"

should have read

"Among the reasons for a form being unable to add records are:

(1) the form's AllowAdditions property is set to No"

Darn! You're right, of course, Linq. Thanks for catching that.
 

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