I have a datagrid in my form. I have a combo box. The datagrid has a field called Employees ID. The combo Box displays the Employee ID. I have another table that has the employee name that is associated with the Employee ID. Is there a way to enter an SQL statement somewhere that will query the Employee ID against my table and display the employee name rather than the ID. This is done in Access97 using an SQL statement in the RowSource. I was hopeing VB has a way to do this similar to Access97 where I could enter an SQL query in the DataSource or DataField parameters. If not then I suppose I can opendatabase, query for info and then close database, but that seems like alot of work for every time you move from one record to another.

Thanks