|
| 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
February 5th, 2010, 04:47 PM
posted to microsoft.public.access.forms
|
|||
|
|||
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
February 5th, 2010, 04:59 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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
February 5th, 2010, 05:02 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
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 | |
|
|
Linear Mode
