ComboBox in Recordset

I want to get the combobox click event, recordset information. I have two tables joined with relation. From slave table I get the emp code and want to get the code description from master file that show description of this talbe in to a label.

How do I manager this

Kim.

I'm not sure exactly what it is you are asking but,maybe this will help:

Try to populate the combobox with the tables joined in the source property.
Using the emp. code for your visible field, and desc. for bound field, then on-click populate the label.caption with combobox.

You could also use combobox to query for the record selected.

If this doesn't help I can give you more info. If I have better details.

Are the combobox and label on the same form?
Is there anything else on this form?
What exactly populates the combobox?
Are you wanting to select a record from the combobox?