Using a field in form as criteria for a query

**otfries** · 07-30-2018, 05:35 PM

I am trying to build a query where the criteria is directly linked to a field in a form. This works except for one problem: I need the query to show all the results if the value in the field is 1. I have the following in there:
IIf([Forms]![fmStorageTransfer]![SupplierName]=1,Null,[Forms]![fmStorageTransfer]![SupplierName])
I need something else than "NULL", but nothing seems to work.

**ssanfu** · 07-30-2018, 05:40 PM

Try

Code:

[Forms]![fmStorageTransfer]![SupplierName] OR[Forms]![fmStorageTransfer]![SupplierName] Is Null

See http://www.theaccessweb.com/queries/qry0001.htm

**otfries** · 07-31-2018, 10:20 AM

Works great. Thanks a lot ssanfu.

**ssanfu** · 07-31-2018, 02:47 PM

You're welcome.

Good luck with your project.....

Using a field in form as criteria for a query

Thread Tools

Using a field in form as criteria for a query

Similar Threads

Field in Report shows entered criteria from [field] criteria in query

Query with criteria a date field of a form

Issue with using a form field as query criteria

How to query using form field as search criteria?

refering a field in a form as criteria in a query problem

Posting Permissions