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've checked both and they are set correctly.

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 did. It now tells me I "can't assign a value to this object"

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...

Thanks for looking, but I got it.

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 =...

Can somebody send me a copy of a simple database that uses dlookup? I've tried all the examples that have been given to me and still keep getting syntax errors. I would really appreciate it.

I tried that first but I don't know VB. I looked at alot of examples but I could never get it to work for me.

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

Thanks for your help. Believe me, I feel like I have tried everything. I copied your code just as you had it and I am still getting this message --> Compile error: Syntax error

It seems I've been working forever on this and can't get it even close to working. Here is the code I am back to using based on Bob's formula above. DLookUp("Product Id", "Qry-Product","WHERE[Manufacturer]=Me.'Manufacturer' AND [Product]=Me.'Product' AND [Description]=Me.'Description' AND...

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 sent the database to you.

Thanks. Let me work with it some more. I took alot of stuff out and it's not working like I had it before. If I still need help, I will send it to you. Thanks for your help. I really appreciate it.

I took out a bunch of stuff and zipped it but it still says it's too big. Can I e-mail it to you? Nancy

This is my new Row Source SELECT DISTINCT [QRY-Product].[Product] FROM [QRY-Product] WHERE ((([QRY-Product].[Manufacturer])=[FORMS]![FRM - Order].[FRM - Order Subform].[Form].[Manufacturer])) ORDER BY [QRY-Product].[Product]; When I select the combo box manufacturer, it still wants me to enter...

Thanks. I will try that.

This is the Row Source in the Product Combo Box SELECT DISTINCT [QRY-Product].[Product] FROM [QRY-Product] WHERE ((([QRY-Product].[Manufacturer])=[FORMS]![FRM - Order Subform]![Manufacturer])) ORDER BY [QRY-Product].[Product];

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...