Filtered Macro Not Referencing Form Using Tabbed Menu

[burrina]

I am using a tabbed menu system with Menu as the name of my Master (page,i.e. Menu)
Main form is named OrderDetails and I have a Unbound Combo on it that uses the macro On Change
Here is the On Change Event Statement: Add an Order and Details Macros.Filter : On Change
It is having a problem referencing the form because of my page I guess.
Name of Main Page is Order Entry
How can I reference the form/page or whatever so that my code will work?
I tried adding Menu to the code;
[Forms]![Menu]![OrderDetails]![Filter]="Today" ' This did not work.

[June7]

Don't understand, you are using a tab control? There is no need to reference the tab control.

If this is a navigation form, then the issue is entirely different.

[burrina]

I inserted pages and then inserted my forms into these.

[June7]

What do you mean by 'pages'? Pages of a tab control or a navigation form?

Again, if this a tab control then refer to subform normally, the tab control is irrelevant. I always name subform container control different from the object it holds, like ctrDetailes. If the code is behind main form, then:
Forms!mainformname!ctrDetails.Form!controlname
or
Fomrs!mainformname!ctrDetails!fieldname

However, a navigation form is different. Navigation forms confuse me. As do macros - I use only VBA.

[burrina]

I created a Blank Form, inserted pages and then inserted my forms into these. So I have a tabbed menu style look. Us mere mortals have to resort to such when pour vba skills suck.

[June7]

I still don't know what you mean by 'pages'. VBA has nothing to do with this. If you want to provide db for analysis, follow instructions at bottom of my post.

[burrina]

OK, here is a scaled down version.Hopefully you can give me some direction.Instructions is on form (Main Form) OrderDetails.

[June7]

There is no tab control, no navigation form and therefore no 'pages'. Now that that is answered...

Note on the form states: I am trying to make the subform subtract items from the Products table.

If that's what you want the update query to do, it is a mess. It isn't updating Products, it updates OrderDetails. Modifying the Inventory field in Products table would be:
UPDATE Products SET Products.Inventory = [Inventory]-[Forms]![OrderDetailsSubform]![Quantity]
WHERE (((Products.ProductID)=[Forms]![OrderDetailsSubform]![ProductID]));

BTW, saving aggregate data like this is usually a bad idea. The summary values are 'disconnected' from the raw data, audit trail is broken, and errors are hard to determine and fix. Ideally, raw data as transactions of inventory purchased/sold would be saved and aggregate data would be calculated 'on-the-fly' when needed.

[burrina]

I don't even understand what you said.However I know the query was messed up. I have since got it figured out. I have also abandoned the Tabs feature.

I thank you for your hard work.
I am trying to finish just one feature of the db at a time. Since this is the Customer Feature, i.e. subtracting inventory. So your saying my approach is bad. Everything is on one form and the only thing I have to implement is the code feature. Next comes the inventory feature, then the invoicing feature. I don't know of another way since I am at my code limit and way past my skill level, of this I am well aware. Still, I will struggle along as best I can.
Thanks Again.