Show table in dropdown?

[PoorCadaver]

Hi,

Searched the forum but could not find this. If I double posted, please show me the correct thread.

I have tblComputers with a column 'user_id' that corresponds to column 'id' in tblUsers. I want to view column 'user_id' in a listbox in tblUsers in a form with various other data from tblComputers so that I can assign the computer to a user. Very basic.

I can do that via the wizard but when I select a user in the dropdown, the tblUsers updates the current id with the new. It overwrites a usernam with the new one I selected and I don't want that. I want it to update 'user_id' in tblComputers with the new id.

How can I do that?

 

[Uncle Gizmo]

See the Video:-

Create a Form with Basic Combo box Lookup

On my website here:-

https://sites.google.com/site/msaccess457966vmfjg/form-controls/combo-boxes/combo-box-videos

 

[PoorCadaver]

Thanks, that helped!