RE: Form/Subform

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

"rg32" wrote:

> 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
> "Sprinks" wrote:
>
> > Hi, rg32.
> >
> > I suspect your AllowFormView property is set to No, and therefore is
> > displaying in Datasheet view.
> >
> > Hope that helps.
> > Sprinks
> >
> > "rg32" wrote:
> >
> > > 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???
.

Relevant Pages

  • RE: Form/Subform
    ... I suspect your AllowFormView property is set to No, ... displaying in Datasheet view. ... > view is still set to single form. ... I don't think it should matter that the subform ...
    (microsoft.public.access.forms)
  • RE: Form/Subform
    ... the form is still displaying as continuous. ... memory messages and things locking up. ... > displaying in Datasheet view. ... >> I have a Form which is set to single form view, with a subform which is set ...
    (microsoft.public.access.forms)
  • Re: NZ #ERROR
    ... I don't know how your DSum is working -- the syntax is incorrect. ... Is the Main Form displaying one Order ID or multiple Order ID's? ... In the footer of this subform are you totalling the Retail Price? ...
    (microsoft.public.access.gettingstarted)
  • Updating combo boxes
    ... Each region can have a unique combination of material types in it, so we want the MTID combo box to automatically requery when the region changes. ... the MTID combo box was not displaying all of the materials for a given region each time you clicked on it. ... Private Sub Form_Current ... BUT now, when scrolling through all of the records using the main form, some data doesn't display in the MTID combo box in the subform still. ...
    (microsoft.public.access.formscoding)
  • Re: AddNew button on the Record selector
    ... displaying the client and a subform displaying the orders and their line ... >>That code shows that there is only one form open and that the subform it ... >>holds is considered to be a control. ...
    (microsoft.public.access.modulesdaovba)