To determine your price based on the material and width, you mey be able to use a DLookup function to get the price from your price table. Save the value of your dLookup to a variable, and then feed the variable's value into a textbox to show the price.


Have you tried using:
[VBA]SELECT DISTINCT PanelType.ID, PanelType.Panel FROM PanelType ORDER BY [Panel];[/VBA]