Using second collumn in Combo Box

[cschnable]

If I have a form with 2 fields, such as Part_Number and Part_Price, and I use a 2 collumn (Part_Number, Part_Price) Combo Box in the Part_Number field to enter the Part_Number.

How do I have the part price automatically be entered into the Part_Price field on the form?

 

[smoker1]

Hi cschnable! Honestly, you're e-mail didn't really give me all the specifics necessary to help you.... So, let me know if this is on the right track.

Do you have a table that has a Part ID and Part Number field? Or are these 2 fields unbound in the form? Is the combo box also on that same form?

If you have it set up the first way, simply place a SELECT DISTINCTROW statement in row source (I can help you with that, if you need it).

Either way, let me know so I can further assist you.

--Angela

 

[LonnieJohnson]

1. In the combo box's Column Count property make sure it is set to 2.
2. In the combo box's AfterUpdate event put...

YourTextBox = ComboBox.Column(1)

ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[cschnable]

Angela -

It is a bound form with bound fields

Part_Description and Part_Price

At the present time I am using a combo box to bring up the part description, and another combo box to bring in the part_price. (both from the same query)

This means that the user has to make 2 selections of the same part to fill both boxes.

I want the user to be able to make one(1) part_description selection from the query and have the price field filled in automatically.

The user must also have the capability of manually changing the price if she wants too.

Thank you for your help - Ken -