comparing value combobox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I'm stuck

This is what I'm trying to acchieve

I want to find out if the selected value of a combobox is already part of a
table.
If not, then a form must open.
 
You should be able to use code like:

If DCount("*","[a table]","[Part of] = " & Me.AComboBox) > 0 Then
or if [Part of] is text
If DCount("*","[a table]","[Part of] = """ & Me.AComboBox & """") > 0 Then
 
Back
Top