query helppppppp!

anonymous_at_discussions.microsoft.com
Date: 03/02/05 

Date: Tue, 1 Mar 2005 20:09:55 -0800

MSDN SQL &| VB &| CHANGE QUERY &| WAIT FOR THE SERVER
>-----Original Message-----
>Help.
>
>I have a query that runs and opens a form. The form has
many records
>associated with it and when the query runs it does not
open to the data you
>just queried on. Does anyone know how the code to get
the form assocated
>with the query to open on the data you just queried on???
>.
>

Relevant Pages

  • Re: conditional formatting in form slows down calculations
    ... >> table to see all dates and a filtered query to see recent dates. ... If I set it to open with the record source the query, ... >> endless calculating when the form opens. ...
    (microsoft.public.access.forms)
  • Re: Filtering records in a form
    ... I have one query, QrySelMainData, pulling data from TblMainData. ... Switchboard Manager to create a switchboard type menu for you. ... form as the form to open when the database opens. ... I have a database of Issues entered by my agents. ...
    (microsoft.public.access.forms)
  • Re: Query Design View is Slow to Open
    ... same query takes about 20 minutes to open in datasheet view. ... took only seconds to open in both design view and datasheet view. ... The troublesome queries are based entirely on local tables (i.e. no ... HOUSEHOLD_PersonalInfo opens slowly in design ...
    (comp.databases.ms-access)
  • Re: Opening additional (non-default) form instances
    ... I'm not completely clear about this, but I suggest you remove the parameter from the source query. ... When I first posted this question, the prompt accepted only ... When the subform opens after the Parm prompt, ...
    (microsoft.public.access.formscoding)
  • Re: Query Design View is Slow to Open
    ... My benchmark query takes about 20 minutes to open in design view. ... Each subsequent time, the query opens ... In the same database, there are many queries that open normally in ...
    (comp.databases.ms-access)