M
Mishanya
I have mainForm with two subforms, linked to the main by ClientID. The
subForm1 is datasheet-view (Orders), while subForm2 is single-view and its
recordsets (Order details) relevant to the subForm1 rows (it gives more
detailed/differently queried look on each row-recordset).
I want to programm subForm1 rows (one of its fields) so dblclicking it would
pass criteria to the subForm2 and make it show the relevant recordset
(OrderID).
The procedure
stLinkCriteria = "[OrderID]=" & Me![OrderID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
do the job of passing the criteria fine, but opens the subForm2 in new window.
1) How can I just "refresh" the recordset of already loaded subForm2 by
clicking row in the subForm1?
2) If I want to have the subForm2 hidden until the subForm1 is clicked, can
incorporate Forms![frmMain]![frmSub2].Visible in the same event?
subForm1 is datasheet-view (Orders), while subForm2 is single-view and its
recordsets (Order details) relevant to the subForm1 rows (it gives more
detailed/differently queried look on each row-recordset).
I want to programm subForm1 rows (one of its fields) so dblclicking it would
pass criteria to the subForm2 and make it show the relevant recordset
(OrderID).
The procedure
stLinkCriteria = "[OrderID]=" & Me![OrderID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
do the job of passing the criteria fine, but opens the subForm2 in new window.
1) How can I just "refresh" the recordset of already loaded subForm2 by
clicking row in the subForm1?
2) If I want to have the subForm2 hidden until the subForm1 is clicked, can
incorporate Forms![frmMain]![frmSub2].Visible in the same event?