This is total newbie question I'm sure, but as my MS Access guru hasn't been hired yet... and I'm trying to get started on my own, here goes.
I'm trying to setup an auto quotation tool for simple metal components. I've setup a number of input text boxes that use a calculation to determine the volume of the component. From there, I have a ComboBox with all the alloys listed which in turn populates a text box with the density of the selected Alloy so I can calculated the weight of the components (Volume*Density).
I have two tables. The first, AlloyDensity, is the list of alloys and their densities. This one obviously won't be changing. The second, AlloyPricing, is a list of the alloys and there $/lb price. This one will need monthly updating. I used the relationship screen to "link" the two tables together by alloy name.
I'm to the point now where I need the $/lb price from the AlloyPricing to populate a text box for use in a calculation, but the ComboBox is referencing a column in the AlloyDensity table.
I'm messing with a DLookUp in the Control Source that looks like this:
=DLookUp("[AlloyPricing]![Price/Lb]"," [AlloyPricing]"," [AlloyPricing]![Alloy] = [Alloy_Value] ")
Where Alloy_Value is what I've called the contents of the Alloy dropdown box.
But that's just going off something I found online as a tutorial and it's not working.