If... And... Then Statement

[eggwater]

what is the correct syntax for this...

I have the following and it doesn't work -


If IsNotNull(.Room_Number) And .Export_ctrl = "4" Then
.Export_ctrl = "1"

can anyone enlighten me on my error - i get the 'Compile Error, sub or Function not defined'

many thanks for whoever can help

 

[SforSoftware]

If Not IsNull(.Room_Number) And .Export_ctrl = "4" Then

 

[namliam]

Just a quick note: "" is empty to our eyes but it does not equal Null!!!
You might want/need to check for that as well..

Regardzzzz

 

[Rich]

Or........ If IsNumeric(.Room etc.

 

[eggwater]

thanks

I solved my problem I think ... though if anything goes wrong I will reassess these answers

cheers