Link to home
Start Free TrialLog in
Avatar of frank_guess
frank_guessFlag for United States of America

asked on

Building a form with a search that allows the user to type in the id or select from the list

I need a combobox on a form that allows the capability to either type in the emplyee id or allows you to move through the list of employees, the combo has two fields connected:
Employeeid and a field call lastandfirstmiddlename
the form will presently move to the first of the numbers but will not allow me to type another number if I do it moves in this example.
24232 it will move to the beginning of the 2's but if I type the 4 it moves to the 4's.  I also need the ability for the information to select the correct record and if I move to the next record for the combobox search to update to the record as I page through them. I need the ability to go to a blank record and then have it add a record that I type into the form the search combobox is on.  Got any ideals or examples that I can get.
ASKER CERTIFIED SOLUTION
Avatar of COACHMAN99
COACHMAN99

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of frank_guess

ASKER

It can be.
Is there a good example of the form and code that I could get a copy of.
Basic fields is employeeid, employeename.
I've requested that this question be closed as follows:

Accepted answer: 0 points for frank_guess's comment #a39941040

for the following reason:

Gave me an idea.