Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kevvan
  • Content: Threads
  • Order by date
  1. kevvan

    Supply Null value in IIF statement as a condition response

    I have a form that calls a query and passes a textbox value to be evaluated in an IIF statement. The textbox value default value is the word blah. The IIF statement looks something like this: IIF ([Forms]![Form1]![txtbox1]="blah", NULL, [Forms]![Form1]![txtbox1]) The logic is that if the...

Part and Inventory Search

Back
Top