Hi
I have a database setup almost identical to this in you tube "Access Order Forms with subforms & macros NCEA L3". what i am attempting to do is, instead of having to select the order ID on the popup subform, i want access to populate it automatically.
i have used [Forms]![OrderForm]![OrderID] in the OrderDetailQuery but it does not work. I have used as the control source on the subform orderID box, it populates the number but does not populate the actual table.
can anyone help?
Thanks
Adam