Results 1 to 2 of 2
  1. #1
    Janoose is offline Novice
    Windows XP Access 2007
    Join Date
    May 2011
    Posts
    7

    How to set recordsource to textbox with vba during run-time?

    I have this table I create during run-time which would store all the extracted information from various tables. My question is how can I display the items into a report? Like what is the command to set the recordsource of the report and control source of the textbox with VBA during run-time?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    In the open event of the report:

    Me.RecordSource =
    Me.TextboxName.ControlSource =
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. record time based on option using textbox
    By stoey in forum Programming
    Replies: 2
    Last Post: 04-14-2011, 08:43 AM
  2. Setting Recordsource for Subforms
    By P5C768 in forum Forms
    Replies: 5
    Last Post: 11-16-2010, 05:01 AM
  3. RecordSource help
    By mann2x in forum Access
    Replies: 3
    Last Post: 10-05-2010, 06:44 PM
  4. Replies: 2
    Last Post: 10-16-2009, 02:47 PM
  5. update recordsource of subform
    By AndyKim in forum Forms
    Replies: 1
    Last Post: 06-16-2009, 09:15 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