Help for If Then Statement

[JJPetersen1]

First line is wrong ... Any help would be appreciated

If [CACorIDcard] = -1 And [IDResaon] = "Lost" Then



DoCmd.OpenForm "frmCE_LostCAC"

Else
End If

[June7]

What does "wrong" mean - error message, wrong result, nothing happens?

Is IDResaon a number type field?

Should "IDResaon" be spelled "IDReason"?

[madpiet]

If [CACorIDcard] = -1 And [IDResaon] = "Lost" Then

Are [CACorIDcard] and [IDReason] control names on your form? If so, you need to prefix those with Me! (points to the form you're running your code from).

If Me!CACorIDcard=-1 And Me!IDreason = "Lost" Then
DoCmd.OpenForm "frmSomeForm"
ELSE
msgbox "Sorry!",vbokonly
End If

[JJPetersen1]

Still not happening (form doesn't appear).
IDReason is a text field
CACorIDCard is a Yes/No field

[JJPetersen1]

If I use one field, it works. I believe the problem has something to do with how the fields are connected. Is "And" correct?

[madpiet]

Can you post just this form and the tables it needs? then we can see what's wrong.

[JJPetersen1]

I couldn't attached the file (too big), even after deleting all the other forms, queries, reports, etc.

I attached a screenshot.

[Welshgasman]

That would lead me to believe the code is working, just that you do not have the combination to open your form. Walk your code line by line with breakpoints and inspect your values. Don't just assume they are correct.

[Welshgasman]

You would need to show the record where those controls are correct, not design view.

[JJPetersen1]

The code is run (After update in the IDReason)

[JJPetersen1]

The break points suggestion was the key. The IDReason is a linked table. I was referring to the field in the table.

THANK YOU