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
307 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 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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

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.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

685 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