Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    sparker75 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    107

    Hi June,

    Isnt the filter called strWhere?

  2. #17
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    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.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #18
    sparker75 is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Jul 2018
    Posts
    107
    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, 08:13 PM
  2. Replies: 5
    Last Post: 05-21-2015, 10:33 AM
  3. Replies: 8
    Last Post: 06-25-2014, 08:03 AM
  4. Replies: 3
    Last Post: 08-18-2013, 09:14 PM
  5. Replies: 3
    Last Post: 02-23-2012, 04: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
  •  
Other Forums: Microsoft Office Forums