[AccessD] change control source via vba

Bob,

    Typically, dynamic assignment of control source might also be accompanied by selective hiding/un-hiding of controls.

    For a practical demonstration covering reports as well as forms, my sample db named MotelBooking might be of interest to you. It is available at Rogers Access Library (other developers library). Link - http://www.rogersaccesslibrary.com/OtherLibraries.asp#Tejpal,A.D.
 
    Second option on the main switchboard, captioned "Booking Status (Style 2) - Dates Across Columns", should be pertinent to your case. You could adapt the underlying approach suitably, for your specific needs.
 
Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Bob Heygood 
  To: Access Developers discussion and problem solving 
  Sent: Monday, September 11, 2006 05:06
  Subject: [AccessD] change control source via vba


  Does anyone have a code snip that will show me how to change a report control from being unbound to one of the fields in the record source of the report??

  This needs to be done either when opening the report or from code I run before opening.

  TIA

  bob