Results 1 to 3 of 3
  1. 04-16-2022, 05:51 AM #1
    mainerain
    mainerain is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Location
    Maine, USA
    Posts
    146

    Run-time error 2162, Find window

    2162, a macro set to one of the current field's properties failed because of an error in a FindRecord action argument.



    Code:
    Me.DeviceSN.SetFocus
Docmd.RunCommand acCmdFind
Docmd.FindRecord"120613"
    Access Find popup form opens but 120613 doesn't get loaded into it because of this error.
    Reply With Quote Reply With Quote
  2. 04-16-2022, 10:53 AM #2
    moke123's Avatar
    moke123
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,879
    Use a filter

    Code:
    StrFilter = "DeviceSN = " & Me.DeviceSN        'If Number DataType
'StrFilter = "DeviceSN = """ & Me.DeviceSN & """"      'If string DataType

Me.Flter = strFilter
Me.FilterOn = true
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks
    Reply With Quote Reply With Quote
  3. 04-16-2022, 10:59 AM #3
    Gicu's Avatar
    Gicu
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,250
    Remove the second line as it is not needed.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Run time error 2465 - can't find the field '1' referred to in your expression
    By moneypennie21 in forum Access
    Replies: 3
    Last Post: 05-31-2019, 01:52 PM
  2. run time error 3011 could not find object
    By jj1 in forum Access
    Replies: 10
    Last Post: 02-18-2016, 09:44 PM
  3. Run-time error '3024': could not find the file 'c:\users\*****\Documents\dbo.mdb
    By Greg Sipe in forum Access
    Replies: 1
    Last Post: 04-30-2013, 05:44 PM
  4. getting run-time error 7874: cannot find object select...
    By gammaman in forum Programming
    Replies: 3
    Last Post: 03-03-2013, 12:22 PM
  5. Run-time error '2465': MS Access can't find the field '|' referred to in your expres
    By Sohail Anjum in forum Programming
    Replies: 1
    Last Post: 12-01-2012, 12:44 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums