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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

747 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now