Autocomplete in a subform does not work

[CarlS]

Hi

I'm still very new to Access and this issue may have been addressed previously but I can't find it.

In my database I have a Products Table. I also have a Returns Table and a Returns Detail Table. The returns and returns detail tables are linked. I enter the returns using a form Returns and a subform with the returns details. In the subform I have the Product Code and Product Description and Price fields. The product Code field is a combo box containing the code, description and price data. When I enter the product code, the description and price fields are automatically entered using an afterupdate event. This works just fine when I only open the subform to enter data but when the subform is embedded in the main form, the description and price fields are not updated when I enter the product code - those fields just stay blank.

Any idea why this would work when the subform is used by itself but not when open in the main form?

The after update procedure I am using is as follows:
Private Sub Code_AfterUpdate()


Description = Code.Column(1)
Price = Code.Column(2)
Supplier = Code.Column(3)
End Sub

Thanks for any suggestions!

[ItsMe]

The way you are describing it, I would not expect any problems. Where is the code for your Code_AfterUpdate Sub Procedure? This should be behind the form that has the combo. Also, the textbox controls, Description, Price, and Supplier, should be on the same form.

If this works by itself, none of this should be changed when using your form as a subform within the main form.

[CarlS]

Thank You, ItsMe

After having looked at the form again, I noticed that the subform wasn't actually a subform. It was the table that Access had inserted into the main form which is why it was never going to work. Anyway, solution found and thanks again for your help!