Limiting the Filter

L

Lori

Okay, the more I use access the more I realize I don't know.

I've got a filter set up on my forms to filter data by project number, using
an unbound combo box the user selects the project number and the data
switches to that project. However it doesn't limit the data to that project,
it only displays that info first. Is there a way to only show the data for
the specific project number and omit the rest?
 
K

Klatuu

That is a whole different issue you are talking about.
What you are doing with the combo is making the selected record the current
record. You can still navigate to any record in the recordset.

My guess is you are using the traditional FindFirst with the RecordsetClone
and setting the form's bookmark to the recordsetclone's bookmark. In this
case, what you want to do is filter the form:

Me.Filter = "[ProjectNumber] = " & Me.cobProject
Me.FilterOn = True

You will need to use the correct names and the correct syntax in the first
line depending on the data type of the Project Number field.
 
Top