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: Search Box
    ... Do this after you've bound the form to a query. ... Click on the Field List icon (toolbar). ... This is the easy way to get bound controls on the form. ... >>>>> you then click on it and it opens that record. ...
    (microsoft.public.access.formscoding)
  • Re: Design View
    ... Can we assume that you put your database is a "trusted" location? ... Try the query again. ... it should print the SQL statement of the query into ... The same query opens fine in design view in Access 2000. ...
    (microsoft.public.access.queries)
  • Re: Table is too large
    ... I don't edit or append against a union query: ... > from the narratives table that are equal to the same SSN as the one they ... > table so that when the form opens it pulls all of the records from the ...
    (microsoft.public.access.tablesdbdesign)