J
JK
I'm getting a RunTime Error 3070.
I'm tying to use one continous form to open another continuous form based on
an account class of trade using the dbl click event.
If I launch the 2nd form on its own and enter BAK, the form displays
correctly... If I use the dbl click event from the 1st form, I get the error
mentioned above.
This is what the 1st form looks like:
BAK BAKERY [VIEW]
" " "
I want to be able to dblclick BAK or BAKERY and have the next Cont. Form
display all of the items assined to that specific class of trade.
This is the code I'm using:
=============================
Private Sub ViewRecord()
DoCmd.OpenForm "frmClassOfferingDetails"
Forms!frmClassOfferingDetails.RecordsetClone.FindFirst "[ClassofTrade]="
& Me.ClassofTrade
Forms!frmClassOfferingDetails.Bookmark =
Forms!frmClassOfferingDetails.RecordsetClone.Bookmark
End Sub
=============================
The 2nd Cont. Form has the following Query Attached to it:
=============================
SELECT tblProductOffering.ClassofTrade, tblClassOfTrade.ClassDesc,
tblProductOffering.ItemNumber, tblItemMaster.ItemDescription,
tblItemMaster.SecondItemDesc, tblItemMaster.ValueClassDesc
FROM (tblProductOffering LEFT JOIN tblItemMaster ON
tblProductOffering.ItemNumber = tblItemMaster.SecondItemNum) LEFT JOIN
tblClassOfTrade ON tblProductOffering.ClassofTrade =
tblClassOfTrade.ClassOfTrade
WHERE
(((tblProductOffering.ClassofTrade)=[Forms]![frmClassOffering]![ClassofTrade]))
ORDER BY tblProductOffering.ClassofTrade, tblProductOffering.ItemNumber,
tblItemMaster.ItemDescription;
=============================
Any help would be greatly appreciated...
I'm tying to use one continous form to open another continuous form based on
an account class of trade using the dbl click event.
If I launch the 2nd form on its own and enter BAK, the form displays
correctly... If I use the dbl click event from the 1st form, I get the error
mentioned above.
This is what the 1st form looks like:
BAK BAKERY [VIEW]
" " "
I want to be able to dblclick BAK or BAKERY and have the next Cont. Form
display all of the items assined to that specific class of trade.
This is the code I'm using:
=============================
Private Sub ViewRecord()
DoCmd.OpenForm "frmClassOfferingDetails"
Forms!frmClassOfferingDetails.RecordsetClone.FindFirst "[ClassofTrade]="
& Me.ClassofTrade
Forms!frmClassOfferingDetails.Bookmark =
Forms!frmClassOfferingDetails.RecordsetClone.Bookmark
End Sub
=============================
The 2nd Cont. Form has the following Query Attached to it:
=============================
SELECT tblProductOffering.ClassofTrade, tblClassOfTrade.ClassDesc,
tblProductOffering.ItemNumber, tblItemMaster.ItemDescription,
tblItemMaster.SecondItemDesc, tblItemMaster.ValueClassDesc
FROM (tblProductOffering LEFT JOIN tblItemMaster ON
tblProductOffering.ItemNumber = tblItemMaster.SecondItemNum) LEFT JOIN
tblClassOfTrade ON tblProductOffering.ClassofTrade =
tblClassOfTrade.ClassOfTrade
WHERE
(((tblProductOffering.ClassofTrade)=[Forms]![frmClassOffering]![ClassofTrade]))
ORDER BY tblProductOffering.ClassofTrade, tblProductOffering.ItemNumber,
tblItemMaster.ItemDescription;
=============================
Any help would be greatly appreciated...