narrowing query results on form

[roadahead]

Hello. A question seeking a solution. I have an unbound form with a
combo box and button the launches a query. The query fills in an
unbound form. The unbound search results form is a form with 4
subforms on tabbed pages. The linked child and master fields are used
to populate the form/subforms. I have several records with the
resulting linked fields. What I want to end up having is no repeat
records on the main forms but as many records a required on the
subforms. In essence limiting the main form result to one record
regardless of the number of records that contain the same field value.

Thanks

 

[Rick Brandt]

Hello. A question seeking a solution. I have an unbound form with a
combo box and button the launches a query. The query fills in an
unbound form. The unbound search results form is a form with 4
subforms on tabbed pages. The linked child and master fields are used
to populate the form/subforms. I have several records with the
resulting linked fields. What I want to end up having is no repeat
records on the main forms but as many records a required on the
subforms. In essence limiting the main form result to one record
regardless of the number of records that contain the same field value.

Thanks

You lost me. You indicate above that the search results form is unbound so how
can it have duplicate records? If that was a typo and the results form is bound
(to a query I assume) you can set that query so it only returns the two fields
you use for linking and then also set it to "Unique Values = Yes" so that you
get no duplicates.

 

['69 Camaro]

Hi.

What I want to end up having is no repeat
records on the main forms but as many records a required on the
subforms.

If these "repeat" records are duplicate records, then you have a problem
with your table structure. It needs a better primary key. If they're not
duplicates, just that all of them have the same value in a particular column
or set of columns, then you can use the built-in filter-by-form feature.

Place the cursor in the text box in the main form that you want to filter
on, then select the Records -> Filter menu and select the appropriate
submenu item.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

Or you can use the built-in toolbar buttons, Filter By Form, Filter By
Selection, and Apply Filter/Remove Filter.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.