Search results

  1. O

    Update multiple fields on combo select

    lol...yea yea yea. I saw that, and of course, I didn't actually look at the Column Count property. I played dumb and thought you meant the number of the column. pbaldy, you rock! Works like a dream! Thanks!
  2. O

    Update multiple fields on combo select

    I have this: Private Sub EmpName_Change() Me.EmpID = Me.EmpName.Column(3) Me.EmpEmail, = Me.EmpName.Column(1) End Sub My script in the EmpName field is simple, basically, select EmpName, EmpEmail, EmpPhone and EmpID in that order. The email does get updated, but the ID doesn't. The ID...
  3. O

    Update multiple fields on combo select

    Thanks pbaldy, but that's blankling out the box. Could it be because I have all the column widths set to 0?
  4. 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...
  5. O

    If Statement in Form

    It does work. Guess a little proofreading goes a long way, huh? Thanks!
  6. 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