Help required! I have two tables; tbtask (fields: id, task, techieID) and tbtechie (Fields: id, technie, Active - Y/N), utilising a one to many relation. The purpose of the Db is to record tasks and assign a technician to the task. I have created a form (frmTask) with the task field and a combo box for the techie so this can be chosen from a pre-defined list. Great, easy. However, what I want to be able to do is filter out techies where the Active field state no. I then added to followng to the row source so only Active techies would be available in my combo (SELECT tbtechie.id, tbtechie.techie FROM tbtechie WHERE (((tbtechie.active)=Yes)); ). This appeared to work fine, the combo box only included the techies that where active. However for existing records the field was showing blank because it wasn't in the list - not really what I had in mind, I needed the combo box to be fitlered but the previous select/field value visiable. Too counter this I then went to the properties of the combo box I then edited the bound properties, this had the desired affect however the combo/field is now showing the techieID and not the technie name, not much use to anyone unless you refer to people as a number - question is, how to I change the display text from the techieId to the techie name? sorry if I have posted twice, i had a problem with ie.