Results 1 to 2 of 2
  1. 10-23-2012, 09:06 AM #1
    RachelBedi
    RachelBedi is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jul 2012
    Posts
    67

    Make result invisible in Form?

    I have a query which displays information from several different audit sources, however in the form for a particular dept is it possible to hide results from other departments? I want to avoid having several queries for the same information just diff depts.



    ie if [AuditSource] = "InternalQC" don't show or something to that effect?!

    Thank you guys!
    Reply With Quote Reply With Quote
  2. 10-23-2012, 09:12 AM #2
    RachelBedi
    RachelBedi is offline Advanced Beginner
    Windows Vista Access 2003
    Join Date
    Jul 2012
    Posts
    67
    Nevermind! I put a filter on the on load event that seemed to do it!
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Make subform control invisible depending on value in mainform.
    By Richie27 in forum Programming
    Replies: 1
    Last Post: 06-15-2012, 05:08 AM
  2. How to Use Search Form Query Result & GoTo Desired Record on Separate Form
    By ANTHROPOIDLUVA in forum Forms
    Replies: 1
    Last Post: 06-09-2012, 05:44 PM
  3. New Version of Invisible Controls In Form View/DE "No" Prop Issue
    By Soule in forum Forms
    Replies: 7
    Last Post: 02-23-2012, 07:19 PM
  4. Another Permutation of Invisible Form Records
    By Soule in forum Forms
    Replies: 2
    Last Post: 01-26-2012, 12:44 PM
  5. Make some controls on a form invisible based on Windows user log in
    By KrisDdb in forum Forms
    Replies: 1
    Last Post: 10-05-2011, 04:36 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