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.
