Search results

I tried "[Forms]![02 Update Order]![00 Products Sub Update]![Product ID]", but I still get "Enter Parameter Value" for "Forms!00 Products Sub Update!Product ID" Only difference is now I get "Enter Parameter Value" for "Forms!02 Update Order!00 Products Sub Update!Product ID" when I try to use...

I believe your link is refering to if you are writting code, but I was most likely doing this incorrectly in the forms Record Source; setting the Product ID Criteria to "[Forms]![00 Products Sub Update]![Product ID]". What should I change the "[Forms]![00 Products Sub Update]![Product ID]" to...

I am doubtful my title properly explains what I am trying to do; I will elaborate. I am trying to get a follow-on form to reference a subform. Here is what I currently have going: I have two (2) tables: 00 Orders and 00 Products; both forms have primary keys "Orders ID" and "Product ID"...

That worked...I cannot thank you enough!

Here is the SQL: INSERT INTO [DelieveryOrders] (Item, OrderNumber, CLIN, Customer, Email, [Contract Date] ) SELECT Orders.Item1, Orders.[Order Number1], Orders.[CLIN Number1], Orders.[Customer Name], Orders.[Customer Email], Orders.[Cont Date1] FROM Orders WHERE (((Orders.Item1) Is Not Null) AND...

I have a form that on open runds 5ea Queries. These queries are used to append needed data to a table where I have 2ea fields set as primary keys to ensure the combination of the two (2) are not added multiple times. I want it to run this way as it supports and works perfectly for the other...

I am getting an error stating "Compile error: Method or data member not found. It is also hightlighting the .ControlName

Upfront - I am knew to Access and this is my first build attempt. I have a requirement to create a database to track our equipment inventory. The inventory is being saved to an "Asset Tracking" table. The fields this table contain include: Item Number (primary key) Category (i.e...