Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Location
    Newport, RI
    Posts
    6

    Unanswered: 'FindRecord' isn't available now

    In VBA, I've created a record as a result of an operator action. When I try to display that record in the current form using FindRecord, I get the following error:
    Error Number: 2046, the command or action 'FindRecord' isn't available now.

    I've tried Me.Requery before doing the FindRecord but it makes no difference. If I close the form and then reopen it, I'm able to display the new record with no problem. Does anyone know what I am doing wrong?

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Just an idea. I'm not sure it will work or not. Try making a Clone of the form's recordset, then do a .findfirst on the new recordset. If you find the record that way, then retrieve the Bookmark, then set the bookmark for the form's recordset to the bookmark you saved from the new recordset. If this method works, that should do it for you.

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Is the form's set to Data Entry = Yes?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Although it seems that you're running FindRecord as a method of the DoCmd object in VBA, I suggest you read the FindRecord Action (macro) in the help file. It has additional pertinent information.

    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •