Goto Last Record that is not "None"

[infinitx]

Hi,

In the Forms OnOpen Event, I want a textbox (txtICL) to go to the Last record that is not "None".

How would I go about doing this?

Thanks a bunch!

----
Alex

Anytime things appear to be going better, you have overlooked something.

 

[PHV]

Take a look at RecordSetClone, FindLast and Bookmak.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[infinitx]

I have this down so far:

    Dim rst As Recordset
    Dim strSearchName As String

    Set rst = Me.RecordsetClone
    strSearchName = Str(Me!ICL_3)
    rst.FindLast "ICL_3 = " & strSearchName
        If rst.NoMatch Then
        Else
            Me.Bookmark = rst.Bookmark
        End If
    rst.Close

I believe that that code is to be used with a combo box.

How would I go about editing it? Where would I set the criteria for the textbox to not display "None" records?

I'm sorry if this is a stupid question, but I would appreciate your help!

Thanks!

----
Alex

Anytime things appear to be going better, you have overlooked something.