Search results

  1. O

    Update multiple fields on combo select

    Hi. What I have is a combo box with a list of employee names. On select, I would like my form to auto fill in the email text field and phone text field. My field names are EmpName, EmpPhone and EmpEmail and these reside in an Employees Database, that is called in a Job form. On the Form...
  2. O

    If Statement in Form

    I have a field called "Days Till Due". If my Job Status Field = "Complete", I want to Days Till Due field to = 0, otherwise do a Date Diff between two existing Date fields. This is what I had, but all I get is #Name? IIf ( [Job Status] = "Complete+ , 0, = DateDiff("d",[Date In],[Due Date]))...
Back
Top Bottom