Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Thanked 0 Times in 0 Posts

    switch autofill (97)

    hi all
    i have a combo box that lists employees and their id numbers

    as it is now, i have the list sorted by employee with the employee as the bound column. if the user starts typing in the name, it will autofill the name from the list.

    is there any way to switch the autofill if the user starts typing in the numbers of the employee's id number? for example, typing "S" might bring up "Smith, John" or typing "4" might bring up the id number "4283" .

    thanks in advance for all help

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: switch autofill (97)

    No. The only way to handle this is to have side-by-side combo boxes. The first box will have 2 columns, Employee# and EmployeeName, column 1 is bound column. The 2nd box will reverse the columns: EmployeeName and Employee#. In BOTH cases, the Employee# column is the bound column!!!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts