Filter for line item of invoice

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

Access 2000

I have an invoice form: Main form and subform.

I'd like to place a combo box on the main form, select a part number and
then in it's after update event, have it filter to show all invoices with
that part number on them.

Here's what I've tried:

Me.Filter = "[Key] = " & Me.cboPartFilter
Me.FilterOn = True

It's not working.

Any ideas?

Thanks.
 
Put the part number field as one of the bounded textboxes onto the main form. Make it invisible. Click on the properties of the subform. Click on the data tab and fill in both the master field and the child field with the part number field. Of course, your sub form should be run off a query that has part number as one of the fields. Then you don't need to have to apply filter to anything

Hope this helps.
 
I want to use this form as the invoicing form as well as being able to
filter for a part number and see all invoices with a given part number.

So I think I want to filter for a part number don't I?

Thanks.



anthony said:
Put the part number field as one of the bounded textboxes onto the main
Click to expand...
form. Make it invisible. Click on the properties of the subform. Click on
the data tab and fill in both the master field and the child field with the
part number field. Of course, your sub form should be run off a query that
has part number as one of the fields. Then you don't need to have to apply
filter to anything.
 
Back
Top