NorthWind Traders Question/Problem

[Thomas]

Hello Help Please!

What I am trying to do is add a ComboBox to the Orders Form from the
NorthWind Traders Database that lists Categories and then limits the
products in the subform to that Category.

I have it almost working using the EditProducts Form from the Solution
Database.

The problem I am having is the statement in the Query LimitProductList
criteria field [Forms]![Orders Subform]![Category] will not pass the info to
ProductID field when the orders subform is loaded from the master form
Orders.

If anyone has been able to or has done this with the NorthWind Traders
database. Would you please share your code or better yet please e-mail me
the database. (e-mail address removed)


System here at the shop is running:
OS windowsXP
MS Access 2003

NorthWind Traders database from Access2003
Solution's database from Access 97

Thanks in advance
Thomas

(e-mail address removed)

 

[Wayne Morgan]

When a form is opened as a subform, it is not considered to be "open". To
refer to it, you have to take a path through the main form.

Example:
Forms!frmMainForm!SubformControl.Form!txtTextbox

SubformControl refers to a control on the main form. This control is what
holds the subform. To get the name of this control, open the main form in
design mode, open the Properties sheet, and click on the subform ONE time.
The properties sheet should show the name of the subform control. If you
click on the subform a second time, you'll be in the subform and the
Properties sheet will show the name of the subform, not the control holding
it. However, if you created the subform by dragging and dropping the subform
onto the main form then Access probably gave the subform control the same
name as the main form.