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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear Combobox Selection not working 0
Copy record info into new form 0
Update subform with combobox change on main form 1
value from combobox or user value 4
Need combo box to refresh when moving to new record 2017 1
Requery Problem in Access 2007 1
Why can't I tab out of a combobox and keep my selection 7
ComboBox unusual behaviour.... 2

Back
Top