Loading values into a 2 column combobox

[RichKorea]

I want to add a log-on screen to the data entry form that our service
engineers use so that next time they log-on, I can pop-up a list of recent
reports they’ve been working on (make it easier to find and update their open
reports). I have a combo box that works off a query to list of all of the
engineers as well as admin people, but rather then requiring the user to have
to either type in their name or scroll through a list of fifty or six people,
I’d like to use their username to populate the combo box with their name so
if that’s their name, they can just hit the log-on button (and if they’re
using someone else’s laptop, they can type or scroll down to their own name).
Getting the username is easy (thanks to Dev Ashish’s fOSUserName function),
but my combo box is two columns, column(0), which has a width of 0â€, is the
ID, and column(1) is the name (which is what shows in the combo box). If I
set the combobox.value = name, there’s a Null in the ID column, which doesn’t
work. I tried combobox.column(0) = ID, but I get an error “424 Object
requiredâ€. Is there a way to load the two values (ID & name) into a two
column combo box?

The tables are on a networked drive, with each engineer running an mde file
on their laptop to access the database. I have not tried using the build-in
security log-on that’s built into Access, as we’re not worried about
restricting access to the database. Main goal is to make things as simple as
possible for the engineers, who typically update their reports at the end of
a long day.

Thanks,
Rich

 

[RichKorea]

After doing some additional digging, I figured out that the columns are
read-only, so there's no way to load the two values I want, so instead, I
changed the combo box to a single column bound to the name (which I've got
set as No Duplicates), and then did a look-up using the name to get the ID.