lasse.staalung
New member
- Local time
- Today, 11:39
- Joined
- Aug 16, 2017
- Messages
- 5
I have a main form with a subform in table view, and a popup continuous form. The reason for the continuous form, is to show the product picure also. I have products in two dimensions, product number and color.
What I want is to send a ColourID from the Popup form to the Subform.
My main form is named "Shop_Orders", my subform "Shop_Order_Detail_Extended" and my popup form Shop_ColorPick.
The Text Box name in the Subform is “Colour” (Old spelling mistake) and in the Pop Up form “ColorNo”
I have tried following vba codes in the event Doubble Click under the Popup Form Text Box “ColorNo” with no success:
[Shop_Order_Detail_Extended].Form![Colour] = ColorNo
Me.[Shop_Order_Detail_Extended].Form![Colour] = Me.ColorNo
Me!Shop_Order_Detail_Extended.Form.Colour = Me.ColorNo
Me.Parent.Shop_Order_Detail_Extended.Form!Colour = Me.ColorNo
Me.Parent.Shop_Order_Detail_Extended!Colour = Me.Colour
Me.[Shop_Orders].Form![Shop_Order_Detail_Extended].Form![Colour] = ColorNo
Parent.Forms!Shop_Orders.[Shop_Order_Detail_Extended].[Colour] = ColorNo
[Forms]![Shop_Orders]![Shop_Order_Detail_Extended].Colour = ColorNo
From a Text Box named “ColorNo” on the Main form this code, works fine:
[Shop_Order_Detail_Extended].Form![Colour] = ColorNo
But from the popup form to Main form this code does not work:
[Shop_Orders].Form![ColorNo] = ColorNo
The eroor message I get is:
Run-time error '2465':
Shop V4.0 cant find he field '|1' reffered to in your expression.
I have tried something about Navigation form and Navigation Subform also, but I am not sure I understand that right.
I am out of ideas, so I would really appreciate some guiding.
Thank you in advanced.
What I want is to send a ColourID from the Popup form to the Subform.
My main form is named "Shop_Orders", my subform "Shop_Order_Detail_Extended" and my popup form Shop_ColorPick.
The Text Box name in the Subform is “Colour” (Old spelling mistake) and in the Pop Up form “ColorNo”
I have tried following vba codes in the event Doubble Click under the Popup Form Text Box “ColorNo” with no success:
[Shop_Order_Detail_Extended].Form![Colour] = ColorNo
Me.[Shop_Order_Detail_Extended].Form![Colour] = Me.ColorNo
Me!Shop_Order_Detail_Extended.Form.Colour = Me.ColorNo
Me.Parent.Shop_Order_Detail_Extended.Form!Colour = Me.ColorNo
Me.Parent.Shop_Order_Detail_Extended!Colour = Me.Colour
Me.[Shop_Orders].Form![Shop_Order_Detail_Extended].Form![Colour] = ColorNo
Parent.Forms!Shop_Orders.[Shop_Order_Detail_Extended].[Colour] = ColorNo
[Forms]![Shop_Orders]![Shop_Order_Detail_Extended].Colour = ColorNo
From a Text Box named “ColorNo” on the Main form this code, works fine:
[Shop_Order_Detail_Extended].Form![Colour] = ColorNo
But from the popup form to Main form this code does not work:
[Shop_Orders].Form![ColorNo] = ColorNo
The eroor message I get is:
Run-time error '2465':
Shop V4.0 cant find he field '|1' reffered to in your expression.
I have tried something about Navigation form and Navigation Subform also, but I am not sure I understand that right.
I am out of ideas, so I would really appreciate some guiding.
Thank you in advanced.