Execution error 3464

[Trisha]

Dear ,

I reused one macro to develop a form in MS access.

The macro fetch the record set corresponding to the reference value from the table.

The refermante value is a numeric field.

The macro code is :

Private Sub Modifiable20_AfterUpdate()
Dim rs As Object
Set rs =Me.Recordset.Clone


rs.FindFirst "[Reference_Number] = ' " & Me![Modifiable20] & " ' "
If Not rs.EOF then Me.Bookmark = rs.Bookmark
End Sub


Please let me know what to change in the above code to make it work

[pbaldy]

The parts in red wouldn't be needed for a numeric field:

rs.FindFirst "[Reference_Number] = ' " & Me![Modifiable20] & " ' "

[Trisha]

Thank you so much it works.

[pbaldy]

Happy to help!