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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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