Auto name input

  • Thread starter Thread starter mike
  • Start date Start date
M

mike

I would like to add a field in my form that will display a list of the user's
as the letters of the last name are typed i.e. auto find.

Is this feature available in access or must it be coded?

thx in advance for the feedback.
 
Allow me to clarify my own question...I have a table of students. I would
like the form to auto fill the student name as the user enters the characters
of the last name. When the user finds the student, user can hit enter and
the last name, first name, and middle name field will populate.
 
Mike-
Do you want the form to bring up the student record (to update/view phone #
etc.), or will you be using the data to create an associated record(s) in
another table (like adding a new class)?

For either, I would use the tools wizard...
Option 1: From the toolbox select the combo box and place it on your form
(make sure the wizard button on the toolbox is selected.) Select the bottom
option "I want the combo box to look up the values in a table or query." The
wizard will walk you through the steps of selecting the data for the combo
box (select your Students table, then the name fields, etc.)
Option 2: From the toolbox select the combo box and place it on your form
(make sure the wizard button on the toolbox is selected.) Select the bottom
option "Find a record on my form based on the value I selected in my combo
box." The wizard will walk you through the steps of selecting the data for
the combo box (select your Students table, then the name fields, etc.) Then
it will ask what you want to do with the data, select "Store that value in
this field:" and select the Student ID field.

When you get that done, there are a variety of ways to get the names to show
 
thx for the info...i'll give it a go but to answer your question...

i have a table of students, each record represents a student.

teacher needs to be able locate student record by typing last name. need
last, first, and middle fields to display as teacher is entering last name.
does that make sense?

we're trying to streamline a paper procedure.

i think your idea will work. will let you know:)
 
I think I'm making this more difficult than it is...

-table of students
-each record represents a student
-each record has the following fields: firstName, lastName, English, Math, etc
-need a form to display/update each record

trying to create a form that will allow teacher to auto find students based
 
Back
Top