Query search record macro with empty field value (1 Viewer)

IvaanGarciia

Member
Local time
Today, 03:28
Joined
Mar 5, 2020
Messages
37
I'm trying to get the record with the field Fecha reception in blank in the search button with text box, But I'm not able to do it. The value that I ingress is the Id_asset.

1585182553728.png


Anyone could tell me what is wrong with it. I only want to get the record in the form... the values with Id_asset that I ingress in textbox that has Fecha_rec field in blank.

1585182679608.png
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:28
Joined
May 7, 2009
Messages
19,175
Code:
If Nz(DCount("1", "[RF Tracking Query]", "ID_Asset = '" & [TextSearch] & "' And IsNull([Fecha Recepcion])"), 0) > 0
 

IvaanGarciia

Member
Local time
Today, 03:28
Joined
Mar 5, 2020
Messages
37
Code:
If Nz(DCount("1", "[RF Tracking Query]", "ID_Asset = '" & [TextSearch] & "' And IsNull([Fecha Recepcion])"), 0) > 0
This will be placed in one If or direct to the apply filter?
 

Users who are viewing this thread

Top Bottom