Filtering

  • Thread starter Thread starter Jacob
  • Start date Start date
J

Jacob

I have an Access 2003 Inventory program. On my main equipment form, I have a
drop down to allow the client to filter on a part number. I used the after
update to fire the code which is this...

Private Sub IDS_AfterUpdate()

DoCmd.GoToControl "PartNumber"
DoCmd.FindRecord PartNumber
DoCmd.GoToControl "Type"

End Sub

This should be filtering my records to that part number but it is not
working. Does anyone have an idea?


Jacob
 
Try using the 3rd choice on the combobox (dropdown) wizard. It will write
the code you need to find a part number.
 
Back
Top