Only What is Chosen

  • Thread starter Thread starter Charles Phillips
  • Start date Start date
C

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
 
Hello,
"Thank You"...


Charles L. Phillips



KARL DEWEY said:
No code needed.

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

--
KARL DEWEY
Build a little - Test a little


Charles Phillips said:
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
Click to expand...
Click to expand...
 
Back
Top