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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...
Column, the column which holds the record ID)
In the combo box's AfterUpdate event, the form is requeried, with
Click to expand...
something like:
Me.Requery
The form is based on a query that points to the form's combo box as a
Click to expand...
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
Click to expand...
query that serves as a source for the form.
 
Back
Top