List box sorting problem

[RichieP]

Hello there you fine Access programmers.

I have a problem with a list box. As you can see in my Access 97' attachment, I have a list box that updates certain boxes on a form. What I need is for the user to be able to narrow the search (by the court name field) in the list box depending on what they type.
For example - if the user needed a court code but only knew the court name (let's say BOSTON) then they would select the court name from the list box. Instead of scrolling all the way down I want to be able to type BOSTON in the list box and it then directs to the BOSTON details. (note that court code is the PK).

Maybe a text box which is bound to the list box could be used to narrow the number of records in the list box?

Who knows? I definetly don't!

Thanks
Rich

 

[Mile-O]

You can't type Boston into a listbox - it doesn't provide that functionality.

As an aside, the field MCC in your court detail tables deserves a table of its own as the MCC (whatever it is) is not dependant upon the court ID.

 

[Idjit]

Another aside: is there a reason why your court and youth court fields are text instead of number fields?

You can't type into a list box, but you CAN type into a combo box. You may want to try that.

 

[Mile-O]

I've restructured the new table for you.

 

[RichieP]

Thanks for your help guys