Results 1 to 2 of 2
  1. #1
    Derrick T. Davidson is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    142

    Populate text box by clicking on a text box

    Hi



    I have a form [frmSuppliers] containing a sub report [rptSubItem] and a text box [txtItem].

    When the suppliers name is entered the sub form [rptSubItem] appears with a list of items provided by the supplier [txtSupItem].

    What I would like to do is click on an item in the subreport [rptSubItem] list [txtSupItem] and the item I click will populate the txt box [txtItem] in the main form [frmSuppliers]

    My code experience is limited so I am unsure if this is possible?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Usually the main form controls the sub form, not yhe other way.
    why are you clicking sub reports? This is a form, reports don't control forms.

    you can set text boxes on the main form from the sub form by...
    on click event...
    Forms!frmMain!txtBox= txtSubBox

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

Similar Threads

  1. Replies: 3
    Last Post: 07-15-2015, 03:14 AM
  2. Replies: 9
    Last Post: 04-25-2014, 12:33 PM
  3. Replies: 6
    Last Post: 10-01-2013, 10:58 AM
  4. Replies: 2
    Last Post: 06-11-2012, 09:37 AM
  5. Replies: 5
    Last Post: 02-10-2010, 12:27 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