Results 1 to 2 of 2
  1. 05-01-2023, 01:56 AM #1
    krag
    krag is offline Medium experience
    Windows 10 Office 365
    Join Date
    May 2014
    Posts
    71

    Specifying sub form for SearchForRecord acObjectName

    Is there a specific string format to specify a sub form in the SearchForRecord command?
    I first set the focus on the target field in the sub form.
    I tried "Forms![MainFormName]![SubFormName].form" but VBA cannot find the form and error is shown.
    Reply With Quote Reply With Quote
  2. 05-01-2023, 02:45 AM #2
    Welshgasman
    Welshgasman is offline VIP
    Windows 10 Access 2007
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,940
    Forms: Refer to Form and Subform properties and controls
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. DoCmd.SearchForRecord odd behavior
    By WCStarks in forum Forms
    Replies: 8
    Last Post: 12-04-2018, 02:11 PM
  2. Referancing form in DoCmd.SearchForRecord when using Navigation form - Access
    By pritesharyan in forum Access
    Replies: 4
    Last Post: 05-12-2015, 03:26 AM
  3. Searchforrecord Subform Combo Box
    By birth19 in forum Forms
    Replies: 5
    Last Post: 09-27-2012, 12:03 PM
  4. SearchForRecord statement
    By crowegreg in forum Forms
    Replies: 5
    Last Post: 06-29-2012, 05:40 PM
  5. Convert SearchForRecord Macro to VBA
    By Phred in forum Programming
    Replies: 4
    Last Post: 02-29-2012, 04:02 PM

Tags for this Thread

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