Searching a Table on a Form Using Drop Down Text Boxes

[Kgwill85]

I need my form to be able to pull information from fields in my table
and list all of the entries entered in that field in a drop down box
on my form. I got one of my boxes to display all the ID numbers, but
when I go to the Name box and click the down arrow for the drop down
options it displays the same ID numbers as the other box. Why doesn't
it show the names instead?

I want the ID box to display all the ID's in it's drop down, and the
Name box to display all the names in it's drop down. Those are the
only 2 boxes on the form.

Also, how do I take those results of the search and then populate
another form with that same information and additional info?

I'll kinda lay it out for you.
SearchForm*
ID #'s dropdown
Name dropdown
search button

- after searching I want it to do this...

ResultsForm*
ID #'s box
Name box
Additional information
Additional information

Basically I want the first form to show all the entries in two fields
in order to perform a search. When you click the search button on the
SearchForm I want it to bring you to another form (which I have made)
that displays ID # and Name boxes of course and all the additional
info that goes with that particular entry.

Thanks in advance if you can understand what I'm looking for.

 

[jahoobob via AccessMonster.com]

Check the Row source property of the name dropdown (combobox) and make sure
that the name field is included. If it is, make sure thast the Bound Column
property coresponds to the name field in the Row source.

 

[Kgwill85]

Check the Row source property of the name dropdown (combobox) and make sure
that the name field is included. If it is, make sure thast the Bound Column
property coresponds to the name field in the Row source.

The names match, so that's not the problem. And the Bound Column only
lets you enter numbers I do believe.

 

[Kgwill85]

The names match, so that's not the problem. And the Bound Column only
lets you enter numbers I do believe.- Hide quoted text -

- Show quoted text -

And in the row coulumn, I can't pick fields that I want to be list.
It's only naming the tables and queries etc.