changing a combo box row sourcewith multi names to only one name in the row source

[jaymin]

I have a combo box with a row source written in a vba module under an IF statement, it populates the combo box with a list of staff names,

Me.cboStaffSelection.RowSourceType = "Table/Query"       
Me.cboStaffSelection.RowSource = "SELECT tblStaff.IDStaff, [Firstname] & "" "" & [Surname] AS FullName, * FROM tblStaff;"

This is ok when staff with the correct security level view this list of staff in the combo box, what i want to do is when staff without the correct security level look in the combo box they see only there name, I have a variable the is the staff name that i can compare, but having trouble to populate the combo with this single name.
It should be easy but have trouble getting.



Thanks

[CJ_London]

Me.cboStaffSelection.RowSource = "SELECT tblStaff.IDStaff, [Firstname] & "" "" & [Surname] AS FullName, * FROM tblStaff WHERE theirname='" & theirname & "';"

substiture 'theirname' with the relevant names you have used in the staff name variable and tblStaff table

[jaymin]

Ajax,
Thanks for your help, sorry for the delay, had to work and could not get to a computer, I thought it might be something simple like that, not that experienced with select sql
Regards
Peter