conditional macro action

[frcastro]

Hello,



I want a macro i have to do a certain action only if a conduction is matched.

i have something like in condition field

[imprimirpressão].[Pres Lida] Is Not Null

it shows me an error.

How can i make it work in macros?

Thanks!

[maximus]

Try:

suppose if the Value of Field EmployeeId is Not Null on Form Main_Form I want a action

If Not IsNull(Me.EmployeeId) Then
Your Code Here

if You want to enter the full reference then:
if Not IsNull(Forms!Main_Form!EmployeeID) then
Your Code here

[frcastro]

its a table not a form!


still possible?

[maximus]

this is an expression that is being used in a query:
If Field a is Not Null "OK" is Displayed and if it is Null the "No" is Displayed


IIf(Not IsNull([Table1].[a]),"OK","NO")

[maximus]

were you able to solve your problem.