Only What is Chosen

[Charles Phillips]

Hello,
I am using MS-Access 2003.
I have created (copied) a process, that allows me to choose the User I want.
The Combo Box, allows me to type the letters of the last name of the User
whose data I work with.
The Combo Box gives a listing of ALL of the 1st letter of the last name of
the User.
Ex: S, displays S-Sz, then every letter after S.
I just want to see S-Sz, or C-Cz.
Can someone point me to some examples???
I have included my code below:

Private Sub Combo90_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Nz(Me![Combo90], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Thank you,


Charles L. Phillips

 

[Guest]

No code needed.

Set the Auto Expand property of the combo box to Yes.

 

[Charles Phillips]

Hello,
"Thank You"...


Charles L. Phillips

No code needed.

Set the Auto Expand property of the combo box to Yes.

--
KARL DEWEY
Build a little - Test a little

Hello,
I am using MS-Access 2003.
I have created (copied) a process, that allows me to choose the User I
want.
The Combo Box, allows me to type the letters of the last name of the User
whose data I work with.
The Combo Box gives a listing of ALL of the 1st letter of the last name
of
the User.
Ex: S, displays S-Sz, then every letter after S.
I just want to see S-Sz, or C-Cz.
Can someone point me to some examples???
I have included my code below:

Private Sub Combo90_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ContactID] = " & Str(Nz(Me![Combo90], 0))
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Thank you,


Charles L. Phillips