Results 1 to 2 of 2
  1. #1
    blocksey is offline Novice
    Windows 8 Access 2007
    Join Date
    Mar 2014
    Posts
    1

    Unbound Text Box to Subform

    Hi I have an unbound text box, that is determined from a users Environ details, and i would like to link this to a subform

    the subform is made from a cross tab query and basically i only want the subform to show the users details which is in the text box



    Any assistance would be greatly apprecaited



    Thanks

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,863
    My approach would be to use the Main Form's On Current event to update the subform's recordsource. A popular approach is to add criteria to the subform's filter criteria. Both techniques require VBA.

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

Similar Threads

  1. Information text on unbound text box
    By randle in forum Forms
    Replies: 3
    Last Post: 06-28-2013, 11:43 AM
  2. Replies: 2
    Last Post: 06-11-2012, 09:37 AM
  3. Unbound Text
    By cbrsix in forum Reports
    Replies: 16
    Last Post: 10-27-2011, 01:27 PM
  4. Using Unbound text boxes
    By rbiggs in forum Reports
    Replies: 4
    Last Post: 08-16-2011, 04:05 PM
  5. Unbound text box truncating text
    By gddrew in forum Forms
    Replies: 0
    Last Post: 03-02-2006, 11:26 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums