Find record on continuous form

[TJBernard]

This should not be that difficult, but I am not able to get the code to work.

I have a continuous form, that is populated by a selection data string (plugs the string into the record source property for the form) once the form opens (depending on the criteria the users choose).

Now that the database is getting large, the users were looking for a way to search a field and go to the record.

I though it would be easy. Put a text box in the form header, with a button. Once the button is clicked, the code would run the Docmd.FindRecord function, and find the criteria they entered in the dataset.

I cannot get the code to work.

Currently I have...

==============================

Dim FindTape As String

Me!Tape.Locked = False
Me!Tape.Enabled = True

FindTape = Me!Tape

DoCmd.FindRecord FindTape, acEntire, Me!Tape, acSearchAll, , acCurrent, True


===============================

And I get the error "A macro set to one of the current field's properties failed because of an error in a FindRecord Action Arguement"

If you have any ideas, let me know.

Thank you for your time!

T.J.

 

[MStef]

Hello Bernard!

Look at "DemoFindA2002.mdb".
Open frmForm1C (it is continuous f.).