Combo Multiple Sources

[TSSTechie]

Howdy folks,

Is it possible for a combo box to look up it's data from 2 seperate tables.

I would like a combo to show ID Name from the table Staff and ID Name from the table Appraisers and then sort the resulting combined list into ascending alphabetical order.

I'd be really grateful if someone could advise me on how to do this.

Thanks in advance

TSSTechie

May The Force Be With You

 

[PHV]

myCombo.RowSource = "SELECT ID,[Name] FROM Staff UNION SELECT ID,[Name] FROM Appraisers ORDER BY 2"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[TSSTechie]

Howdy,

Thanks a lot for that. All sorted now.

Thanks again

TSSTechie

May The Force Be With You