Requery? Need to avoid duplication!

[Young20]

is there a way that I can compare the ID number from a combo box selection and a table... in order to avoid duplicating that same entry?

ie
If me.cbo1.column(0) = [table name].[field] then
me.cbo1.column(0) and me.cbo1.column(1), etc... = vbWhite

End if

What I am ultimatly trying to accomplish is a way to get rid of one selection in a combo box after it has been selected once and used for another record. is the .requery a better method... if it is, can someone please elaborate on how to use that a little more.

 

[Rickster57]

exists

You could use the dlookup function to see if it already exists.

 

[mic907]

here's a link to an easy solution:

http://office.microsoft.com/en-us/access/HP051875641033.aspx