Good Morning,
Thanks for everyone's help. I'm currently working through an issue and was wondering if someone can help me out.
Data Environment: Two tables with a one to many relationship
Form: Two subforms. Subform 1 = Table A, Subform 2 = Table B
Goal: highlight a record located in table A and have the many records appear in table B
Basic Mechanics: When a record row is highlighted in Table A, a textbox updates with the primary key of that record. The textbox's record source is a query. And then table B is suppose to update based upon the primary key in the textbox with the primary key. I am not using the record selector within the table; I turned that off.
Issue: Can't capture the event when a different record in table A is selected, after the initial record is selected.
What is Working: The initial record selection choice (Enter, Event)
Event's that I've tried:
1. Subform_Enter
2. Textbox_AfterUpdate
3. Textbox_BeforeUpdate
4. Textbox_Change
5. Textbox_Dirty
6. Textbox_Current
7. Form_Current
What confuses me: the subform only has 2 events; 1) Enter 2)Exit
Can someone point me in the right direction?
Thanks,
BrainExplodingFromCoffee