Results 1 to 3 of 3
  1. #1
    shylock is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Sep 2018
    Location
    Dayton, Ohio
    Posts
    100

    Returning form a second form

    I have 2 forms, form A and Form B. I pass a value from Form A to Form B. Form B uses the value to query a list to choose from. I may choose 1 or more items. The chosen items appear in a text box. I want to return these items to a certain list box on form A.

    Two questions: 1. What is the best way to return the items to Form A? 2. How do I return the items to the specific list box on form A?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    i would use an append query to add items to a table...the listbox looks at that Picked table.

    you can update anything using the full paths:
    forms!frmA!txtBox1=forms!frmB!txtBox2

    use the BUILDER to get the paths correct.

  3. #3
    shylock is offline Competent Performer
    Windows 7 64bit Access 2013 64bit
    Join Date
    Sep 2018
    Location
    Dayton, Ohio
    Posts
    100
    Thank you, ranman. Used both your suggestions but did not have to use the BUILDER. The full path solution worked like a charm.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-27-2015, 07:01 AM
  2. Returning to a specific tab on a form
    By stardust1979 in forum Modules
    Replies: 2
    Last Post: 01-14-2015, 05:03 PM
  3. Returning a specific count on a web form
    By Bobwords in forum Forms
    Replies: 9
    Last Post: 07-07-2014, 12:58 PM
  4. Returning a recordset for a form
    By Newby in forum Access
    Replies: 6
    Last Post: 02-28-2013, 09:59 AM
  5. Form returning last blank table row
    By Dannat in forum Forms
    Replies: 5
    Last Post: 01-30-2012, 08:36 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