drop down list

  • Thread starter Thread starter Dave C.
  • Start date Start date
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.
 
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.
 
(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.)
 
Back
Top