By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,982 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,982 IT Pros & Developers. It's quick & easy.

Access Drop Down menu

P: 2

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.
Jul 5 '08 #1
Share this Question
Share on Google+
3 Replies

Expert 5K+
P: 8,127
you need to pass the product name to the query dynamically to find the related price from database.
Jul 7 '08 #2

P: 2
what query are you talking about?

Jul 7 '08 #3

Expert 5K+
P: 8,127
the query you are using to fetch data from database.
Jul 8 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.