If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Filtering
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 |
#2
|
|||
|
|||
Filtering
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 "Jacob" wrote in message ... 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 |
#3
|
|||
|
|||
Filtering
LOL...what a blond moment! Thanks...worked great!
"Arvin Meyer [MVP]" wrote in message ... 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 "Jacob" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|