text box and subform

[rajcin]

I have telephonebook.mdb with one table where I store dates for users.
I need one form with few text boxes and a subform, this form I want to use for searching users names, numbers, PINs,company info etc.
Is it possible to link for example [F/L name] text box with subform so when I enter character in text box, subform should display all names that starts with that character ( something like WIN index help )
Should I put some code behind OnChange event on text box,should I make antoher table or query for the subform and how I can link text box from the main form with the subform.
Thanks
Goran

 

[hennep]

Maybe this sample from

http://www.allapi.net

is usefull
It is a sample for visual basic but it can't be difficult to port it to access.


'This project needs a ListBox, named List1 and a TextBox, named Text1
Private Declare Function SendMessage Lib "user32" Alias "SendMessageA" (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Integer, ByVal lParam As Any) As Long
Const LB_FINDSTRING = &H18F
Private Sub Form_Load()
'KPD-Team 1998
'URL:

http://www.allapi.net/

'E-Mail: KPDTeam@Allapi.net
'Add some items to the listbox
With List1
.AddItem "Computer"
.AddItem "Screen"
.AddItem "Modem"
.AddItem "Printer"
.AddItem "Scanner"
.AddItem "Sound Blaster"
.AddItem "Keyboard"
.AddItem "CD-Rom"
.AddItem "Mouse"
End With
End Sub
Private Sub Text1_Change()
'Retrieve the item's listindex
List1.ListIndex = SendMessage(List1.hwnd, LB_FINDSTRING, -1, ByVal CStr(Text1.Text))
End Sub