Results 1 to 4 of 4
  1. #1
    leonhuynh2006 is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2011
    Posts
    9

    Taking values from rows in subform to a textbox in a mainform?

    Dear all pro and bro,

    Please help me out this situation:

    I have a subform named "tbl_Sending" and a mainform "tbl_Customer". The data in the subform is varied by the condition in the mainform. Suppose that the subform is satisfied a given condition and it list 3 rows of data including 3 different dates (row1: 1/11/01, row2: 15/11/01, row3: 30/11/01). How could I take these 3 dates into a textbox named "txt_deliver" in the mainform following this format: date1, date2, date3 (It should be: 1/11/01, 15/11/01, 30/11/01).

    Forgive for my English.



    I am very appreciated for considering and helping,

    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    See if this link helps, remembering that your SubForm has a RecordSource that you can access. http://allenbrowne.com/func-concat.html

  3. #3
    leonhuynh2006 is offline Novice
    Windows XP Access 2003
    Join Date
    Oct 2011
    Posts
    9
    Thanks, but you have another way around? I just know the simple VBA....

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Not really, sorry.

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

Similar Threads

  1. Replies: 1
    Last Post: 11-29-2011, 02:17 PM
  2. Replies: 1
    Last Post: 11-29-2011, 01:37 AM
  3. Link between subform and mainform
    By crowegreg in forum Forms
    Replies: 2
    Last Post: 08-24-2011, 07:05 AM
  4. MainForm/SubForm question
    By 10 Gauge in forum Forms
    Replies: 5
    Last Post: 03-04-2011, 07:46 AM
  5. Replies: 0
    Last Post: 03-14-2009, 12:33 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