Search results

  1. S

    IIF Function and Comboboxes

    The following shows me the results from a table with checkboxes that were checked or not. The ~ separates the different items, there are actually several other checkboxes not shown here. The user prefers to see text on report rather than checkboxes, so if check box wasn't checked then nothing...
  2. S

    Validation Rule or somthing

    Sometimes I just feel stupid. I have a number field, "EmployeeClock", that is indexed in the table with "Yes (No Duplicates)" turned on. So in the form what I want is when someone tries to edit the "EmployeeClock" number and that number is already being used in that table in that field they...
    • sps2
    • Thread
    • Replies: 1
    • Forum: Forms
  3. S

    IIF (I want it to cancel or do nothing)

    Hello all, first time on the fourm. IIf(IsNull([forms]![DateSelectionWO]![OrganizationCombo]),"",[forms]![DateSelectionWO]![OrganizationCombo]) This is checking a form to see if a selection was made in a combo box "OrganizationCombo". If so then the report show the records matching the...
Back
Top Bottom