Default value combo box current user

[Mary]

I've tried code in other posts, no luck so far. I have a module that
captures the users ID "pcusername()".

I have a combo box on a form that displays a list of managers. Using query
builder, column 1 in the underlying query is their ID which will match
pcusername(). I want the default value for the Manager combobox to display
the managers name which is in column 2 of the underlying query.

Thank you!
Mary

 

[Paul Shapiro]

And to display the 2nd column instead of the first, set the column widths
property to 0;2", assigning 0 for the 1st column width to hide it.