Default value combo box current user

  • Thread starter Thread starter Mary
  • Start date Start date
M

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
 
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.
 
Back
Top