Multiple Column Combo box

[Ollie_3670]

I have a combo box with multiple columns which are: (UsergroupID;UserGroupName;Password) Currently only two usergroups are used, "administrator" and "admissions tutor". These reside in TblSecurity

Columns 0 and 2 are hidden, and column 1 is used to select a user name. This works fine for the first time of logging in, however after logging in I've noticed something peculiar.

After logging in the "Administrator" usergroupName in tblSecurity changes to either "1" or "2". So then if I try to log in again my combo box gives me the option of choosing "1/2" or "Admissions Tutor".

If I login as an administrator, the administrator record changes it's name to "1"
If I login as an Admissions Tutor, the administrator record changes it's name to "2".

Any Ideas?

 

[HiTechCoach]

Sounds like yoiu have the combo box bound to the table with the incorrect column. My guess is that the combo biox probably shoudl be unbound or bound to another table.

 

[Ollie_3670]

Cheers, I'll have a look at it tonight! Haven't been able to get on here much recently..the forum always seems to be updating!

 

[Ollie_3670]

Right, the control source is currently set at usergroupname with the row source being TblSecurity and the bound column being 1

I changed it to the primary key, the UserGroupID, and the bound column 0 but then I couldn't change the values in my combo box :/

Any ideas?