Solved

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

Posted on 2014-03-17
4
312 Views
Last Modified: 2014-03-27
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.
0
Comment
Question by:frank_guess
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 500 total points
ID: 39935718
If the bound column is the ID then typematic should work, and will find 2, 24, 24.. etc.
The second column has the text data. and col widths both have to be > 0

Is col 1 (ID) sorted in the query?
0
 

Author Comment

by:frank_guess
ID: 39941036
It can be.
0
 

Author Comment

by:frank_guess
ID: 39941040
Is there a good example of the form and code that I could get a copy of.
Basic fields is employeeid, employeename.
0
 

Author Comment

by:frank_guess
ID: 39958774
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.
0

Featured Post

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question