Convert code VBA to expression in query (1 Viewer)

[azhar2006]

Hello friends again
I need help converting this code from VBA to an expression in a query. I've tried hard and failed to turn it into an expression.

If Not IsNull(Me.txtsucc) Then
        strWhere = strWhere & "([Success] = """ & Me.txtsucc & """) AND "
End If

Thank you very much

 

[plog]

Me won't work in a query, so you need the full path to txtsucc. Then it would look like this:

...WHERE (([Success]=[Forms]![YourForm]![txtsucc]) OR ([Forms]![YourForm]![txtsucc] IS NULL))...

 

[azhar2006]

Me won't work in a query, so you need the full path to txtsucc. Then it would look like this:

...WHERE (([Success]=[Forms]![YourForm]![txtsucc]) OR ([Forms]![YourForm]![txtsucc] IS NULL))...

IIf(IsNull([Forms]![frmMastr]![txtsucc]);[Success];[Forms]![frmMastr]![txtsucc])

 

[CarlettoFed]

Nz([Forms]![frmMastr]![txtsucc];[Success])

 

[azhar2006]

Nz([Forms]![frmMastr]![txtsucc];[Success])

thank you ,dear CarlettoFed . amazing