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!
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!
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
its a table not a form!
still possible?
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")
were you able to solve your problem.