I have a form created called "View_Orders" it has a subform called "Order", I have added a button to open a new form but its not working getting error saying it cant find "ORDER_ACCOUNT_NO" referred to in your expressions. guessing its because the field is within the sub form
DoCmd.OpenForm "New Form", acNormal, , "[Order_Number]=" & Me![ORDER_ACCOUNT_NO]
How would I go about changing the form to look at "View_Orders" sub form?
DoCmd.OpenForm "New Form", acNormal, , "[Order_Number]=" & Me![ORDER_ACCOUNT_NO]
How would I go about changing the form to look at "View_Orders" sub form?