Access Drop Down menu

[soldier]

Hey.

I'm doing a pretty simple database here; not to verse in access.

One problem I am encountering is with my combo box. The combo box's name is Product Name. I want so that when I select a product the price ( Product Price ) come up automatically.

Both these fields are in a table called Products.

In the expression builder for after update of the combo box I use the following:

Me.[Product Price] = Me.[Product Name].column(5)

Column 5 being the column Product Price is in.

I get a compile error saying Method or data member not found and the .column is highlighted.

Any assistance is greatly appreciated.

Thanks in advance.

[debasisdas]

you need to pass the product name to the query dynamically to find the related price from database.

[soldier]

what query are you talking about?

:|

[debasisdas]

the query you are using to fetch data from database.