I have a combo box that displays the names of all the users in my "Users"
table. I set the RowSource to a Query from the "User" and "Project" tables.
I can select any name from the list and that name comes up in the combo box
on the form. Everything works fine this way I just want to automatically
put the user name in the combo box display.
Is there a way to automate displaying a name in the combo box without having
to use the drop down.
I get the current users ID number by using an API call (thanks to Ken Getz).
After the call returns the ID I take that value and place it in a hidden
textbox on my main form.
????? How do I get the name from the "User" table that matches this ID to
displayed in the combo box? The combo box is already populated with names.
?????
I tried using the RowSource property with a select statement but that only
limited the list to the user name that matched the ID. It did not display
it in the combo box though, you still had to select it. I figured that was
because the RowSource property only puts data in the rows and does not do
the displaying of the data.
I do not want to lose the list of users, I just want to display the logged
in one.
I use the ID to filter the records in a list box on the form and other
things.
Thanks.
Dave N