SalesID on parent form not populating in child form

[Adam1970]

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

[Adam1970]

have sorted it thanks.

for info i added a combobox with a default value of [Forms]![OrderForm]![OrderID] and stored the value in the orderid field on the subform popup

[June7]

This isn't a form/subform arrangement. It is opening an independent form. Don't use a combobox unless you want to allow user to change OrderID, instead use a textbox and set it as Locked Yes and TabStop no.

If you did use form/subform arrangement, then could set the Master/Child Link properties to automatically populate foreign key.