Results 1 to 2 of 2
  1. #1
    Headford is offline Novice
    Windows Vista Access 2007
    Join Date
    Aug 2012
    Posts
    2

    Listbox parameter Query

    This is my first post so go easy on me. I have a listbox which is linked to word documents. Is it possible that when a word document is selected it prompts a parameter query that when entered is linked to the word document. So if the paramater query is entered with a staff number it populates the word doc with this

    Regards

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,619
    Sounds like Access/Word mail merge. AFAIK, the merge can only work with fields. So if the query filters to only those records with that staff number then that will be the only value under the field StaffNumber. The merge will therefore have only that staff number for the word doc to use.
    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. Replies: 1
    Last Post: 07-26-2012, 11:45 AM
  2. Replies: 7
    Last Post: 06-05-2012, 03:22 PM
  3. Listbox value to query parameter
    By steve1040 in forum Programming
    Replies: 1
    Last Post: 01-04-2012, 09:21 AM
  4. Display RESULTS of Query into LISTBOX?
    By taimysho0 in forum Programming
    Replies: 6
    Last Post: 11-22-2011, 10:05 PM
  5. Replies: 29
    Last Post: 02-13-2011, 01:21 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