Results 1 to 6 of 6
  1. #1
    soulice is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    16

    Modal right choice for quick filter query form?

    Want to provide users a way to choose from a few dropdowns to build a query, show the results in a datasheet, then click save and load the result set into another table.



    Questions: can you access form fields on the parent form?
    does this make sense?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Not really.

    Why would you want to 'load the result set into another table'?

    Yes, can reference fields on parent form.
    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. #3
    soulice is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    16
    In this case, the user wants to query a table to records that meet a certain criteria, then load the ID, and 3 other fields into another table. Think invitation list, we pick 30 people from the main table based on filters and then load their details into the "invited" table. Not my design, but it is what the customer wants their existing db to do.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    User doesn't understand relational database concepts? Wants to do things the hard way. A SELECT query with table joins and filter criteria can serve as the 'invited' table. Otherwise, need to use an INSERT SELECT sql action.
    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.

  5. #5
    soulice is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2011
    Posts
    16
    Agreed, agreed and agreed. Would you modal this if real-estate on the main form is lacking?

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    By 'modal' do you mean open another form? Running out of room on main form? Try tab control.

    This shows one method for a search form http://datapigtechnologies.com/flash...earchform.html
    The query could be the 'invited' table and the RecordSource for a report.
    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.

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

Similar Threads

  1. Can't cancel the ‘find’ dialog in modal form
    By AndrewAfresh in forum Access
    Replies: 0
    Last Post: 09-23-2011, 11:12 AM
  2. Modal Form Operator
    By mm07nkb in forum Forms
    Replies: 5
    Last Post: 09-01-2011, 10:53 AM
  3. Replies: 1
    Last Post: 02-17-2011, 06:23 AM
  4. Replies: 6
    Last Post: 02-10-2011, 09:58 AM
  5. How do I put a multi-choice option on my form?
    By Dollydriver in forum Forms
    Replies: 13
    Last Post: 02-09-2011, 05:40 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