Display data from 2nd table column,by picking option in 1st?

[Novice]

Hi
I have a combo box drop down list allowing a user select a part. This drop down list is the first of two columns in a table.
I would like to have another text box in the same from that will automatically display the item in the second column of the table that is on the same row as the part selected.
I'm sure there is an easy way to do this but have not found it yet.
Thks
Novice

 

[EXCEL_Guy]

Re: Display data from 2nd table column,by picking option in

Use the ON EXIT event in the 1st cboBox to trigger the query to update the contents of the 2nd cboBox. Also, use the enable\disable to make the second cboBox disabled until the 1st cboBox receives some event, and vice-versa.

This will force data integrity for the queries.

Place cboBox(s) on FORM | {use wizard to set-up} | Right Click on CONTROL | choose PROPERTIES | click EVENT tab | build EVENT PROCEDURE for your queries.




HTH...Toad