Results 1 to 3 of 3
  1. #1
    Tracyd is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    4

    Question DataMacro

    I have a form, with a sub-form, from which a call a datamacro to calculate totals(from the same table as the control source of the sub-form) and then want to display the totals on the parent form!! The RETURNVARS all have the correct total values, but i cant assign them to a control on the parent form!! none of the controls are recognized when i try and set the PROPERTY VALUE to the totals? (spellings are definately correct)


    PLEASE HELP!!

  2. #2
    Robeen is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Mar 2011
    Location
    Tulsa, Oklahoma.
    Posts
    1,596
    Can you post the syntax that you are using to attempt to assign variables to the controls on the parent form?

  3. #3
    Tracyd is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    4
    i am using the SETPROPERTY macro command, which uses parameters for the value assigned to the control. the variable assigned to the control on the parent form is txtTotPlantsIn (total of detail on subform).

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

Similar Threads

  1. access lookup datamacro
    By izzy2001 in forum Access
    Replies: 2
    Last Post: 11-16-2011, 08:40 PM

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