Lookup buttons... 4

[amandarose80]

I have a form that is a list of names... I want to be able to have buttons at the bottom of the form ie (A-D), (E-G), etc. When the E-G button is clicked the cursor would go to the first record that begins with an 'E'. (the rest of the records after that would display under the 'E's, obviously.) Is there a way to set this up?

 

[chrissie1]

yes ther is a way
but it depends on how good you are in vba

"What a wonderfull world" - Louis armstrong

 

[FancyPrairie]

In the OnClick event of each button, call a function and pass it the letter. Like this:

OnClick... =FindName("E&quot

Function FindName(strLetter as string)

Me.RecordsetClone.FindFirst "name like '" & strLetter & "*'"
If (Not Me.RecordsetClone.NoMatch) then
Me.Recordset.Bookmark = Me.RecordsetClone.Bookmark
End if

End Function

 

[amandarose80]

I'm a little lost...