I tried your code and most of it worked for me. Here is my SQL:
SELECT USERS.Last_name,USERS.First_name,USERS.User_id;
FROM INVENTORY!USERS USERS;
ORDER BY USERS.Last_name,USERS.First_name;
INTO CURSOR MyCursor

It works right by bringing up the list of users (last name, first name, and id) in alphabetical order, and it is searchable. My problem is when I first pull up the record, the combo box displays the last name, not the user_id. Also after picking one of the records, it puts the last name in the field. I have the controlsource set to computers.user_id and the boundcolumn is set to 3.

This shouldn't be this difficult. Is there an easier way to populate a field with information from another database?