Filtering

[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

 

[Arvin Meyer [MVP]]

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

 

[Jacob]

LOL...what a blond moment! Thanks...worked great!

Try using the 3rd choice on the combobox (dropdown) wizard. It will write
the code you need to find a part number.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com