I have a table with all users (Staff in my case) on which I base a query 'Menu List - BC Officers'. The field which I bring through to my form is OFFNAME.
I do this by creating a COMBO BOX and selecting the ROW SOURCE property as below;
SELECT [Menu List - BC Officers].OFFNAME FROM [Menu List - BC Officers];