Selection Criteria

[Gary S]

Hi All,

Problems with this selection criteria:

IIf([Forms]![frmcustomsearchinquiry]![txtgeo]=-1,"like
*",[Forms]![frmcustomsearchinquiry]![cboGeography])

If it's not equal to -1 it works fine.
But if it's not equal to -1, the "like *" doesn't work at all.

Would greatly appreciate some help.

 

[Gina Whipp]

Gary,

Would help me if you stated what you are trying to with this statement and
where you have it.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm