if then else?

[Young20]

I have a form that has four combo boxes, one for events and the other three for different people. the event is selected and then three people to work that event. Each of these people have a cell of information on the database that has "unavailable dates". I am trying to make it so that if the person's unavailable day matches the date of the event a message box pops us saying that this person is unavailable. i was doing that with an if then else statement

if me.official.column(10) = me.Games.column(3) Then
msgbox "this person is unavailable for this day!"
end if

where me.official.column(10) is a combo box as well as me.games is a combo.

any help to help me get this working would be great!

Thanks

 

[RuralGuy]

Are they dates? If so then you need to enclose in octothorps "#".

 

[Young20]

They are dates... but what needs to be enclosed in #? Could you elaborate a bit please.