How to use key find a record ?

[jvincent]

Hello to all,
Little new in Access i would like to know how to use the key to find directly to a record in a table.
ie : i have a table where the primary key (unique) is a date, using VBA i would like to know the instruction to find directly the record 01/06/2004 for exemple.
Thanks in advance.
VINCENT

 

[RuralGuy]

If your form is bound to the query/table you wish to search then:

Dim FindDate As Date
FindDate = #01/06/2004#
Me.RecordsetClone.FindFirst "Format([[B]PrimeKey[/B]],'Short Date') = #" & FindDate & "#"
If Not Me.RecordsetClone.NoMatch Then
    Me.Bookmark = Me.RecordsetClone.Bookmark
End If

...replacing PrimeKey with your key name.

 

[jvincent]

Thank you very much RuralGuy, i will try.