Search results

  1. D

    Need to select from listbox and open form to that record

    Hi, I have a form where people can enter new employees. If they enter in a last name that matches a current employee, I have a pop-up form asking them to check for duplicates. There is a listbox on this form that contains possible duplicates, for example Jane Smith Joe Smith Bob Smith What I...
  2. D

    Error with DoCmd.RUNSQL Update code

    I am trying to update a date field (enddate) in a table (tbl_employees) with the value of a text box (TerminationDate) in a form. The format of the text box is set to short date. Private Sub TerminationDate_AfterUpdate() Dim termdate As Date termdate = Me.TerminationDate.Value If Not...
  3. D

    Searching a subform from a textbox on main form

    I have a main form, frm_search, based on a table, tbl_people. The main form has a subform, sfrm_people. All I want to do is have the user type all or part of the person's last name on the main form, and have a list of ALL people with the matching string in the subform. i.e. If there are two...
Back
Top Bottom