?
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
Medium Priority
?
320 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
  • 3
4 Comments
 
LVL 7

Accepted Solution

by:
COACHMAN99 earned 1500 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month4 days, 18 hours left to enroll

601 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