Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2001
    Location
    indiana
    Posts
    130
    Thanks
    0
    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
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 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
  •