I have a form and sub form which is going to be a purchase orders form. In the subform, I choose a product from a combo and the relevent part is displayed in a text box. The problem I have is that I need another textbox to display a description of the part. The information is stored in the same table as the product?

Your combo box should have several columns. Any field you want to autopopulate when you select something in the combo box should be one of them. in the AfterUpdate event for your combo box, you can simply use: Me.[TextField] = Me.ComboBox.Column(1)

Keep in mind that for multi-column combo boxes, the count starts at 0.

If you get lost, there is a lot on this under the search "populate combo column".

HTH,
David R

David, I'll try implimenting this solution soon. I find the big problem for a beginner with Access is knowing these terms e.g. 'Populating', so it helps a lot when you can provide the method. Many Thanks.

TAC

No problem. I often have to try three or four different searches before I find the answer I want. Experience leads you to being a better search engine...

David R