Verifying information is the same is 2 separate combo boxes

[Voltron]

I have two combo boxes that contain information that needs to match. The combo boxes are Assignment ID and User ID. I have these choices in the combo boxes directly linked to the field in the table where they can be located.

The table that these two need to match up in are in a table for reassigning work. The Assignment ID is an autonumber from its original table and UserID is an actual ID that is typed in in the originating table.

I would like to make it so that the user must make sure that the Assignment ID that is chosen matches up with the User ID that is chosen.

I tried making it so that the user can view both columns in the drop-down list in the combo box and so that the input is bound to the correct column, but when my code...

If comboAssignmentID <> comboUserID Then
MsgBox ("Your Assignment ID and UserID do not match. Please double check this.")
End
End If

... is executed it always gives me the error message. I assume this is because it is storing a number in the Assignment ID and a different ID (anything consisting of alpha-numerics for up to 10 characters) in User ID.

Any ideas on how I can fix this/get this to work?

 

[pbaldy]

Something like this?

comboAssignmentID.Column(1)

Did you delete a thread from yesterday? I followed the link from the email notification, and the thread had been deleted.

 

[Voltron]

Something like this?

comboAssignmentID.Column(1)

Did you delete a thread from yesterday? I followed the link from the email notification, and the thread had been deleted.

Yes, I accidentally did. My computer at work has been having problems across the board, including internet connection and graphics issues. I meant to put a poll in and because of some glitch with the screen I deleted it.

Sorry about that.

 

[pbaldy]

No big deal, I was just curious. Did the column property solve this problem?

 

[Voltron]

No big deal, I was just curious. Did the column property solve this problem?

Yes it did. I just got it working.

Thank you for your help. It is really nice to know that a noob like me can get help from knowledgable professionals like yourself.