problem for an expert
I found some code on this forum that works beautiful but I would like to increase it's functionality. What I have is a Vendor form with a Parts datasheet subform within it. I have a search command button that opens a search box and then allows the user to do a full search. Then the user can select one of the results which in turn sets the gets the VendorID. The problem is the code I have returns to the Vendor form and looks for the VendorID record but I need it to find the vendor record then the part record in the subdatasheet.
I have a file that is simplified to exactly what I am referring to in this problem but I can't make it small enough to post so if someone will please email me I can send it to you or you can download it at
http://www.instrumentsofwealth.com/Needhelp.zip
Anyone with some experience with a problem like this, your help will be greatly appreciated.
Thank you in advance
I found some code on this forum that works beautiful but I would like to increase it's functionality. What I have is a Vendor form with a Parts datasheet subform within it. I have a search command button that opens a search box and then allows the user to do a full search. Then the user can select one of the results which in turn sets the gets the VendorID. The problem is the code I have returns to the Vendor form and looks for the VendorID record but I need it to find the vendor record then the part record in the subdatasheet.
I have a file that is simplified to exactly what I am referring to in this problem but I can't make it small enough to post so if someone will please email me I can send it to you or you can download it at
http://www.instrumentsofwealth.com/Needhelp.zip
Anyone with some experience with a problem like this, your help will be greatly appreciated.
Thank you in advance
Last edited: