Form/Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Form which is set to single form view, with a subform which is set
to continuous form view. When I view in form view however, the Main form is
showing up as continuous also. I check the properties again and the default
view is still set to single form. Is there something else I'm missing that
can somehow change the view? I don't think it should matter that the subform
is continuous, but just to see, I tried changing it to single form view and
the main form still displayed as continuous anyway. I have command buttons
in the footer of the main form and I can't even see them because of the main
form repeating over and over. Does anyone have any ideas what might be
causing this or how to fix it???
 
Hi, rg32.

I suspect your AllowFormView property is set to No, and therefore is
displaying in Datasheet view.

Hope that helps.
Sprinks
 
The "Views Allowed" Property was set to both, but it wasn't displaying as
datasheet. I changed it to Form only, and the default view is still set as
single form. However, the form is still displaying as continuous. It
wouldn't really matter except that I have a Report that is based on this form
so that I can print with only the selected records on the subform. The
report is also showing the Main form information twice.

My scroll bars are not displaying in my form either even though I have the
property set to display both. Could these things be a sign that there is
something wrong with my database? Or could these things be caused by a
computer that is low on memory? I had problems a few weeks ago with low
memory messages and things locking up. IT dept. told me they'd install more
memory, but I don't think they've gotten around to it yet. I haven't had
any messages lately, or anything lock up, but is it possible the low memory
could cause symptoms like this?

Thanks for any help or ideas
 
It certainly sounds like something is wrong; I've never seen that behavior.
I would make a backup copy, and then try Tools/Compact and Repair. If that
doesn't fix the form, I think I'd try creating the main form again, and
pulling the subform in again.

Good luck.
Sprinks
 
Back
Top