HI, i have three select boxes in a form which the values are used to get data , the two date fields work fine and the value is being plugged in the query e.g ( [Forms]![frmNotPaidOutRequest]![ActiveXCtl14].value ) this works fine and i get my desired result. I then have another select box which is populated by a table of names which has just one column. The problem is when i select a name from this select box the value is not being plugged in the query e.g [Forms]![frmNotPaidOutRequest]![sites].value . The weird thing is if i populate this select box with manual values it picks it up no problem..