Re: How to search for a form according to a field other than record nu

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 01/12/05 

Date: Wed, 12 Jan 2005 04:20:23 -0800

Jesse

We're not there, so we have no idea how your data is organized, or what your
forms look like, or what queries they may be based on.

Having a "form of the 'Jones' family" sounds like an unusual design. Does
this mean you have created a different form for each family?

The data in Access tables is generally not organized in any particular
order. You have to use queries to impose some "sort" order. Apparently,
your record number is the primary key, and Access, by default, uses that for
order. If you want a different order, use a query and sort in it.

You could use a combo box on a form to select "Jones family", then use that
selection to load your form.

The process would work something like this:

> User selects record from combo box. (The combo box has, as it's Bound
Column, the column which holds the record ID)
> In the combo box's AfterUpdate event, the form is requeried, with
something like:
        Me.Requery
> The form is based on a query that points to the form's combo box as a
criterion for the record ID, something like:
        Forms!YourForm!cboYourComboBox
> The record ID selected in the combo box is used as the criterion in the
query that serves as a source for the form. 

-- 
Good luck
Jeff Boyce
<Access MVP>
"Jesse" <Jesse@discussions.microsoft.com> wrote in message
news:AA5AC081-5754-4304-B0DE-499BB20124D2@microsoft.com...
> Hi
>
> My forms are usually in the order of record number.  I usually want to
find
> forms according to last name.  I dont want to sort the forms in the order
of
> last name to find the record I'm interested in.
>
> Is there a way to jump to the form of the "Jones" family? (ie: without
> knowing the record number)
> Like create a search field or something?
>
> Thanks!
> Jesse

Relevant Pages

  • RE: Query sort not working after NULL column
    ... There is no sorting in any of the queries except the last one. ... that and sort when the query is run from VB. ... UNION ALL but I'm sure that will complicate things even more and lead me to ... have to insert even another extra query to get rid of the duplicates. ...
    (microsoft.public.access.queries)
  • List box (and queries) not sorting dates or showing correct headers
    ... There are actually two search screens, ... query name from sys_GAPSSortBy, and then a requery is performed on the ... The queries show the same data but have different sort orders - why ... There are two queries which sort on a formatted date field (ascending ...
    (microsoft.public.access.formscoding)
  • Re: "Smart querying" to speed up?
    ... To Rick's suggestions I'll also add that a rough rule of thumb is to have ... in my case I'm doing a "simple" query that draws the material ... construct more efficient queries. ... sort of "sequential queries"... ...
    (microsoft.public.access.queries)
  • Re: ORDER BY [Time] field not working right
    ... Don't sort your query. ... Use the sorting and grouping dialog in the report ... "Denny W. Jones" wrote in message ...
    (microsoft.public.access.reports)
  • Conditional "Is Null" Query Criteria
    ... Question deals with linking tables in queries. ... I'm trying to find all the records that are in "Master", ... If I put "Jones" in the criteria section of query, ...
    (comp.databases.ms-access)