how to move to a specific record? 1

[jamaarneen]

Hi,

when i open the form, i would like the form should go to a specific record.

the form is bound to a date-field (named ReqDel_Date), and i would like that the record containing the current date (if no current - the the next) should get the focus.here is what i tried, but no result:

          Dim rs As Recordset
        Set rs = Me.Recordset
        rs.FindFirst "ReqDel_Date = #" & Format(Date, "yyyy-mm-dd") & "#"

the code is rightnow in the Current_event (what I think I should put into the Open or Load event)

Thank you Ja

 

[PHV]

In the Load event procedure of the form you may try this:

Me.Recordset.FindFirst "ReqDel_Date>=Date()"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jamaarneen]

Thank you PHV

It works great!!!