I've got a subform with a combo box in it. When the user selects from the combo box I'd like it to look in a table and add a value into a textbox on the subform. How do I do it?
Thanks
Si

Use the technique that I recommended to another poster earlier today.
http://www.access-programmers.co.uk/ubb/Forum1/HTML/005396.html

Thanks, but I need to calculate another field from it so how do I do that?
Thanks
Si

You haven't provided much information so I'll make some assumptions to give you an example of what you want.
Assumption 1 - the combo box is selecting a part.
Assumption 2 - you have two related fields that are now part of the form's recordset (since you used the join technique I suggested). These fields are PartDesc and PartPrice
Assumption 3 - you want to calculate the TotalCost for the item being ordered and show it in an UnBound control.

To show this information, place the following calculation in the UnBound control

=Me.ItemQty * Me.PartPrice

Thanks, I now realise I was being stupid, and I have now sorted the problem,
Si