Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18

Open a Form in Datasheet View from Navigation Form

  1. #16
    sparker75 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    95
    Hi June,



    Isnt the filter called strWhere?

  2. #17
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,138
    No, that is just a variable holding string to facilitate building criteria to set Filter property. That variable is only available for reference in the button click procedure it is declared in. Since you want to open second form via a different button click, reference the form's Filter property to retrieve the criteria.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

  3. #18
    sparker75 is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    95
    Ok. Makes sense. Thanks again June!

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. want dialog form to open in datasheet view
    By gunitinug in forum Access
    Replies: 2
    Last Post: 09-04-2017, 07:13 PM
  2. Replies: 5
    Last Post: 05-21-2015, 09:33 AM
  3. Replies: 8
    Last Post: 06-25-2014, 07:03 AM
  4. Replies: 3
    Last Post: 08-18-2013, 08:14 PM
  5. Replies: 3
    Last Post: 02-23-2012, 03:48 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
  •  
Tech Forums: Microsoft Office Forums