Hi, After trying to do this for a while, I came up with the solution.

I have a form to insert/modify users, and a sub-form to display the existing users. On a combobox, I have 2 columns, column 0 with some IDs and column 1 with their corresponding descriptions. On my sub-form I have several columns, including the description. The idea was to click on a user, and get all his data filled on the form.

So I put this on the sub-form...

Hi,

I'm having issues setting a multi-column combobox in the right way.

What I'm trying to do is that when I click on a table (access 2007 subform), a form should fill with the values of the record I clicked on.

No problem until I have to fill correctly a multi-column combo for 2 reasons:

- In the table I only have the value of one of the 2 columns (That can be solved if I query again one...