ChuckRobert
Board Regular
- Joined
- Feb 26, 2009
- Messages
- 64
I have a single form called “frm_Projects_UpdateProject” that uses a variety of controls to filter the main form query, generating a list of projects that meet certain criteria. The Primary Key is ProjectRef (an autonumber).
To the right side of this form, I have a small subform that lists all projects that are contained within this filtered group, in an abbreviated way.
The textbox On Click function for this hyperlinked subform uses “ProjectRefLinked” to get the matching reference number I want pulled up on the main form.
Using MsgBox Forms!frm_Projects_UpdateProject!frm_ProjectsFilterQuery_HyperlinksSubform.Form.ProjectRefLinked confirms the correct reference number is being requested.
Using MsgBox Forms!frm_Projects_UpdateProject![ProjectRef] confirms the current main form reference number.
I have tried a variety of methods, but have not been able to get the main form to select the record that matches the reference number clicked on the subform. Any suggestions, would be greatly appreciated!
To the right side of this form, I have a small subform that lists all projects that are contained within this filtered group, in an abbreviated way.
The textbox On Click function for this hyperlinked subform uses “ProjectRefLinked” to get the matching reference number I want pulled up on the main form.
Using MsgBox Forms!frm_Projects_UpdateProject!frm_ProjectsFilterQuery_HyperlinksSubform.Form.ProjectRefLinked confirms the correct reference number is being requested.
Using MsgBox Forms!frm_Projects_UpdateProject![ProjectRef] confirms the current main form reference number.
I have tried a variety of methods, but have not been able to get the main form to select the record that matches the reference number clicked on the subform. Any suggestions, would be greatly appreciated!