General information
Category:
Forms & Form designer
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only