|
|
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" wrote:
[Quoted Text] > 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.
|
|
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
on the form!
Jill
"mike" wrote:
[Quoted Text] > 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" wrote:
>
> > 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.
|
|
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:)
"Mrs. Ugh" wrote:
[Quoted Text] > 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
> on the form!
> Jill
>
> "mike" wrote:
>
> > 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" wrote:
> >
> > > 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.
|
|
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
on last name. combo box works for last name but i cannot get other fields to
populate once a student is selected?
"mike" wrote:
[Quoted Text] > 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:)
>
>
> "Mrs. Ugh" wrote:
>
> > 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
> > on the form!
> > Jill
> >
> > "mike" wrote:
> >
> > > 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" wrote:
> > >
> > > > 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.
|
|
|