philwickens
New member
- Local time
- Today, 07:34
- Joined
- Jan 3, 2006
- Messages
- 5
I have searched similar posts to solve this, but havn't been able to make it work yet, so apologies if this sounds like an existing post.
On my form (frmContacts) I have a combo box (LstCompany) that lists companies. The default value is set to "N" (so this is the value when nothing is selected).
I have a query (qryContacts) that retrieves records of People and their Companies from a single table (tblContacts - this table includes the fields 'Person' and 'Company'. Some people have no company). I want this query to:
- When no company is selected in LstCompany: show all people (whether or not they have a company).
- When a company is selected in LstCompany: show records for that company.
I have added the following expression to my query:
Expr1: IIf(([Forms]![frmContacts]![LstCompany])="N",True,([Forms]![frmContacts]![LstCompany]))
Criteria = True
This works fine for showing all records, but the Expr1 field returns #Error if a Company is selected.
Any idea what I am doing wrong, or what will work?
On my form (frmContacts) I have a combo box (LstCompany) that lists companies. The default value is set to "N" (so this is the value when nothing is selected).
I have a query (qryContacts) that retrieves records of People and their Companies from a single table (tblContacts - this table includes the fields 'Person' and 'Company'. Some people have no company). I want this query to:
- When no company is selected in LstCompany: show all people (whether or not they have a company).
- When a company is selected in LstCompany: show records for that company.
I have added the following expression to my query:
Expr1: IIf(([Forms]![frmContacts]![LstCompany])="N",True,([Forms]![frmContacts]![LstCompany]))
Criteria = True
This works fine for showing all records, but the Expr1 field returns #Error if a Company is selected.
Any idea what I am doing wrong, or what will work?
Last edited: