Built a form with a datasheet view subform. I now need to add a second datasheet subform dependent on a value from the first subform. I found this link that suggests placing a text box on main form to capture the value. http://www.fmsinc.com/MicrosoftAccess/Forms/Synchronize/LinkedSubforms.asp
Here is the issue, I know the field that needs to be obtained, but I want to have the value posted to the main form based on the currently selected row of the subform data sheet. Whichever row or field user single clicks on is what should trigger the event. I tried the click event of the subform and it didn't fire. I also tried the click event of the detail and that did not fire either.
I don't want it based on having to click or double click the specific field as would prefer the second form to be populated based on what row the user is working on in the first subform rather than having to tell them in order to see the correct data you need to click on the "product code" field as the product code field already has an event tied to it. The other reason is that the first subform will display multiple product codes, so if user doesn't remember to click on the product code, the second subform won't reflect the data for the specific product code. If you need more clarification, please let me know.
Here is the issue, I know the field that needs to be obtained, but I want to have the value posted to the main form based on the currently selected row of the subform data sheet. Whichever row or field user single clicks on is what should trigger the event. I tried the click event of the subform and it didn't fire. I also tried the click event of the detail and that did not fire either.
I don't want it based on having to click or double click the specific field as would prefer the second form to be populated based on what row the user is working on in the first subform rather than having to tell them in order to see the correct data you need to click on the "product code" field as the product code field already has an event tied to it. The other reason is that the first subform will display multiple product codes, so if user doesn't remember to click on the product code, the second subform won't reflect the data for the specific product code. If you need more clarification, please let me know.