Results 1 to 2 of 2
  1. #1
    mes5464 is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2013
    Location
    Aurora, CO, USA
    Posts
    4

    Re-query Field Based On Selection

    I am trying to do an Access App for SharePoint.

    I have two fields Venue, Service Manager.


    Based on the users choice in Venue, I need to filter Service Manager.
    I created a query with a parameter of VenueID and use that for the rowsource of Service Manager.
    How do I re-query Service Manager with the VenueID so that the user can only select Service Managers that belong to the Venue?

    Surely Microsoft saw the need for this.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I know nothing about SharePoint but don't controls have an AfterUpdate event you could use?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Field selection based on quey results
    By Xarkath in forum Access
    Replies: 1
    Last Post: 06-14-2013, 04:37 PM
  2. Field visibility based on ComboBox selection
    By cactuspete13 in forum Forms
    Replies: 3
    Last Post: 01-30-2013, 03:37 PM
  3. Replies: 10
    Last Post: 11-21-2011, 02:56 AM
  4. Populate a field based on combobox selection
    By rscott7706 in forum Access
    Replies: 5
    Last Post: 06-02-2011, 03:18 PM
  5. Replies: 0
    Last Post: 04-17-2008, 09:24 AM

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