Search results for query: *

Nevermind I figured out how to use an If statement to make it work. Under value I put =IIf([Quantity1]=0,0,Product1.Column(1)) that did the trick.. Thanks everyone though

Since some of the Value fields are not populated i get the same thing. I basically need a way to have those be 0 unless i choose a product...then i would need it to return the correct value for the product. i have Source=Product1.Column(1) and that works great, but I cant get it to default 0...

I am not storing the calculations, but for the other calculations to work i need these to work. This is what it looks like. Product Quantity Value Total Product1 110 10 1100 Product2 50 8 400 Blank 0 Blank 0 Blank...

That is exactly what i did. The information is not stored simply displayed. It is then used in calculations after that. I do have another question though. After getting that to work I have a text box where a number is entered. Then I have that box that autopopulates with the correct number. I...

Perfect! Worked like a charm. Thanks TheAceMan1. And thank you everyone else that was trying.

Ok using that logic I came up with =DLookUp("Standard Time","Products","Product = " & Forms![Team Information]!Production_Product1.Column(1)) For the database that I linked above. Only problem is that it doesnt work.

Here is a copy of what i have been trying to work on. In the form I want to be able to select an item from the combobox and have the next field dlookup the corresponding value from the products table. I tried to put in a dlookup but it doesn't work...

Ok I am trying to make an access database form and having trouble figuring out how to do one function I need. I have a table that has names and values for those names. Product1 17 Product2 19 Product3 5 Now. In the form that i have I have made a combo box that lists all of the...