Search results

I used this same code in another form, but it wont' work on this form. Can you see something that I am missing? SELECT DISTINCT [TBLProduct].[Product] FROM TBLProduct WHERE ((([TBLProduct].[Manufacturer])=[FORMS]![FRMRECEIPT].[FRMRECEIPTSUBFORM]!Manufacturer)) ORDER BY [TBLProduct].[Product];

I have my report set up. When I go to print, it prints like I want it but then I get another page with just my header information. How do I get just the one page?

I keep getting a data type mismatch in the following code: Me!Address = DLookup("[Address]", "TBLCustomer", "[CustomerID] = '" & Forms!FRMORDER!CustomerID & "'") I am trying to lookup address when it matches the customer id. This is how the customer id is coded: SELECT DISTINCT...

I am using a dlookup to lookup the product id when the manufacturer and product in the form matches the manufacturer and product in the table. It works fine with just the manufacturer. The type mismatch comes up once I add the And "[Product] part of the code. Me!ProductID =...

I am trying to get a field to automatically populate based on fields selected from combo boxes. Would a SetValue macro be what I need? I can't seem to get it to work. Thanks. Nancy

I have a form and subform that I finally got to work. I now need help with the dlookup for price. I have 3 combo boxes - product, description, and size. Based on those 3 items, I want the price to automatically populate. I think I need to use a dlookup but I'm not sure how because price will...

I asked this question before and need more help. I have a form (orders) and a subform (order details). In the Order Details Form I have combo boxes for Manufacturer, Product, etc. The combo boxes work as I want them in the Order Details Form. All of my combo boxes depend on what was...

I asked this question last week and was told I didn't have the subform properly linked but I don't know how else to link it. Here's the problem. I have a form (orders) and a subform (order details). In the Order Details Form I have combo boxes for Manufacturer, Product, etc. The combo boxes...

I have a form (orders) that contains a subform (order details). I have several combo boxes in the subform that works fine with the subform alone. When I go to the form and try to use the combo boxes, it wants me to enter a parameter. The parameter is in the previous combo box. It's not...