Start options change subform update? - ADO DAO RDO RDS

This is a discussion on Start options change subform update? - ADO DAO RDO RDS ; In a database I have a subform. The record source for this depends on two succesive select-queries. Their sql content, set by VBA code, depend on settings in the main form. The subform works well, but only if I've used ...

+ Reply to Thread
Results 1 to 2 of 2

Start options change subform update?

  1. Default Start options change subform update?

    In a database I have a subform. The record source for this depends on two
    succesive select-queries. Their sql content, set by VBA code, depend on
    settings in the main form.
    The subform works well, but only if I've used the shift-key to bypass an
    AutoExec macro, ie when I'm redesigning it. When I start the DB in the
    normal way, the subform either don't update the content according to settings
    in the main form, or crash. No error messages.
    The Start options for the database hide the database window, hide full menus
    etc to prevent normal users from changing the design
    The DB is designed in Access 2002, on a WinXP, all uppdated.
    Suggestions on what's wrong and/or how to work around it?

  2. Default Re: Start options change subform update?

    On Tue, 11 Dec 2007 00:28:01 -0800, CarinKg
    <CarinKg@discussions.microsoft.com> wrote:

    If you suspect that the startup options contribute to the problem
    you're observing, temporarily comment out that code and try again.

    -Tom.


    >In a database I have a subform. The record source for this depends on two
    >succesive select-queries. Their sql content, set by VBA code, depend on
    >settings in the main form.
    >The subform works well, but only if I've used the shift-key to bypass an
    >AutoExec macro, ie when I'm redesigning it. When I start the DB in the
    >normal way, the subform either don't update the content according to settings
    >in the main form, or crash. No error messages.
    >The Start options for the database hide the database window, hide full menus
    >etc to prevent normal users from changing the design
    >The DB is designed in Access 2002, on a WinXP, all uppdated.
    >Suggestions on what's wrong and/or how to work around it?


+ Reply to Thread

Similar Threads

  1. subform adding rows after update
    By Application Development in forum ADO DAO RDO RDS
    Replies: 1
    Last Post: 11-18-2007, 11:20 AM
  2. subform control change
    By Application Development in forum ADO DAO RDO RDS
    Replies: 2
    Last Post: 10-24-2007, 08:59 PM
  3. populate subform after update
    By Application Development in forum ADO DAO RDO RDS
    Replies: 13
    Last Post: 10-18-2007, 07:13 PM
  4. set start options for access 2007
    By Application Development in forum ADO DAO RDO RDS
    Replies: 1
    Last Post: 10-02-2007, 06:11 AM
  5. Can't change subform recordsource in Access 2007
    By Application Development in forum ADO DAO RDO RDS
    Replies: 0
    Last Post: 06-20-2007, 06:06 PM