Hello,
I’m having a problem when I put the following code on a DblClick event of a form that I open from my sales order form which organizes info for me:
DoCmd.OpenForm "frmSalesOrders", acNormal, , "[SO]=" & Me![SO]
It opens the form (actually the form is never closed because i am coming from the same form just on a different tab) and to the correct record, however the subform of that form is not matched to it.
Is there additional code that I can add to this that will remind the subform to open to the new Sales order I choose?
The subform is named: fsubProductNew and the master and child link field is [SO]
One more explanation scenario – I am starting off by opening my sales order form (which contains a subform and whichever record i move to the subform follows fine)
If the form opens to sales order #5 then the subform matches to sales order #5
Next I open a form from that form that lets me search sales orders customers and organize some other info for reporting.
On that form I would like the ability to double click the SO(sales order) field which would take me back to the original Sales order record, however when I do this with the code I posted above, the subform remains on whichever record the form originally opened to while the main form has gone to the Sales order selection that I just double clicked, so my code is doing half of what i want.
Thanks for any suggestions,
Brian
I’m having a problem when I put the following code on a DblClick event of a form that I open from my sales order form which organizes info for me:
DoCmd.OpenForm "frmSalesOrders", acNormal, , "[SO]=" & Me![SO]
It opens the form (actually the form is never closed because i am coming from the same form just on a different tab) and to the correct record, however the subform of that form is not matched to it.
Is there additional code that I can add to this that will remind the subform to open to the new Sales order I choose?
The subform is named: fsubProductNew and the master and child link field is [SO]
One more explanation scenario – I am starting off by opening my sales order form (which contains a subform and whichever record i move to the subform follows fine)
If the form opens to sales order #5 then the subform matches to sales order #5
Next I open a form from that form that lets me search sales orders customers and organize some other info for reporting.
On that form I would like the ability to double click the SO(sales order) field which would take me back to the original Sales order record, however when I do this with the code I posted above, the subform remains on whichever record the form originally opened to while the main form has gone to the Sales order selection that I just double clicked, so my code is doing half of what i want.
Thanks for any suggestions,
Brian