How to find Records by date in Forum

[kashif]

i am using to find records in forms with this codes.if i want to fin
the records by date .i mean my field type is date.how can i find
any body can help me.Thanks
Private Sub cboSelect_AfterUpdate()

' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[autonumber] = " & Chr$(39) & _
Me![cboselect] & Chr$(39)

If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Su

 

[Guest]

Sooo if cboselect is a DATE why do you have it being
compared to a number?

 

[John Vinson]

i am using to find records in forms with this codes.if i want to find
the records by date .i mean my field type is date.how can i find
any body can help me.Thanks
Private Sub cboSelect_AfterUpdate()

' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[autonumber] = " & Chr$(39) & _
Me![cboselect] & Chr$(39)

If Not rs.EOF Then Me.Bookmark = rs.Bookmark

End Sub

If the field your searching is named [datefield] rather than
[autonumber], change the FindFirst line to

rs.FindFirst "[datefield] = #" & Me!cboSelect & "#"