drop down list

D

Dave C.

I have two combo boxes. One contains "Job Name" the other is "Job Number".
When I select the "Job Name" from the drop down list, my form goes to the
selected "Job Name". If I go back to the drop down list, the last "Job
Name" is at the top of the list. But on the "Job Number" drop down, every
time I go back to the list, it starts with the first job number. How can I
get the list to start with the last "Job Number I selected?

Also, how can I get the "Job Name" combo box to match whatever I type into
the box. Right now, the typing has to match the name exactly from left to
right. For example if a job name is "City of New York" I have to start with
"City". How can I change it so that if I type "New York" it will find the
"Job Name in the list?

Thanks in advance.
 
J

Jeff Boyce

Dave

It sounds like you are describing something termed "coordinated combo boxes"
or "cascading combo boxes". Try Googling on these terms, checking Access
HELP, or visiting the mvps.org/access website.
 
D

Dave C.

(Why can't I see this message in my list. If I "search" for the message it
shows up, but I can't see it in the normal viewer window.)
 
Top