Create form similar to MS Access 2000 Help - Index form

  • Thread starter Thread starter Cabby
  • Start date Start date
C

Cabby

Is it possible to create a form that works similar to the Help - Index form
in Access 2000?
My StreetTable consists of the following fields: Street_ID(autonumber),
StreetName(text), Directions(memo).

I want to be able to type the beginning letters of the street and the List
of StreetNames
continually reduces until I see the street I need in the StreetNames window.
I would then
click on that street and the Directions would appear in the third window
panel.
Since I'm dealing with approx. 5000 streets, scrolling really isn't an
option that I want to consider.

I found that a combo box sort of does the job, but it looks clunky.
If this project or something similar has already been discussed, could you
refer me
to that page or thread.

TIA,

Cabby
 
I've simulated what a combo box does in a listbox, here is the code I used:

Private Sub KW_Change()
' Dynamic search as text entered
Dim strSQL As String
strSQL = "SELECT T1 FROM tblKWFlat WHERE" & _
" T1 Like '" & Me!KW.Text & "*' "
Me.lstKW.RowSource = strSQL
Me.lstKW.Requery
End Sub

As you can see you need the Change event and you must use the .TEXT property
of the control.

-Dorian
 
mscertified said:
I've simulated what a combo box does in a listbox, here is the code I
used:

Private Sub KW_Change()
' Dynamic search as text entered
Dim strSQL As String
strSQL = "SELECT T1 FROM tblKWFlat WHERE" & _
" T1 Like '" & Me!KW.Text & "*' "
Me.lstKW.RowSource = strSQL
Me.lstKW.Requery
End Sub

As you can see you need the Change event and you must use the .TEXT
property
of the control.

-Dorian
Click to expand...


Thank you. This works like a charm.

Cabby
 
Back
Top