Enter values in table from form

[Josh]

Hi, I am working on a form that uses 3 combo-boxes that are linked to
populate only with the data that is related to them (basing value of control
on another control).
Here is an example... model # is selected, the color box is populated with
the colors that are available for that model # and finally, the accessory
package available for those models in those colors. I have not had any
issues up to this point, but the problem comes in when I try to populate a
text box with the price. I want it to be in a text box so that if this
changes, an associate can easily click through the combo boxes and update the
price. All of the data is being pulled from one table.

Any suggestions as to how to go about doing this would be greatly
appreciated. Let me know if any further explanation is required.

 

[Josh]

I tried to write a dlookup function, but I am not totally familiar with the
format... If it would be helpful, I can post it.

Thanks