Check for NULL value

[RDS2]

Is there a way to to check for a null value in a custom dialog box/pop-up form and assign default values if that is the case? I want to do this as criteria in a query field.

 

[scriverb]

Use this as an example of the SQL for a query to populate your popup form:

Select A.*, IIF(IsNull(A.YourFieldName), default value, A.YourFieldName) as YourFieldName
FROM tblYourTableName as A;

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[dhookom]

Where [SomeField] Like NZ(Forms!frmA!txtSomeValue,"*&quot

Duane
MS Access MVP