[AccessD] change control source via vba

Hello A D,
Thanks for taking the time to respond.
It appears that you are using queries to arrange the data, without actually
modifying the form controls.

This might have been a better way to do what I am doing, but I am now too
far into another method.

best,

bob



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of A.D.TEJPAL
Sent: Monday, September 11, 2006 5:27 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com