Results 1 to 4 of 4
  1. #1
    libraccess's Avatar
    libraccess is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Napier New Zealand
    Posts
    129

    Assign Value to Control from Calculated Field in another Form

    The problem -All suppliers but one supply in Litres (the other Kg). Currently if the supplier is selected in ControlB a pop up form with unbound box for Kg and another with the conversion formula. So I close the form and type the calculated value to ControlC ( assuming I can remember the number and my yptos oops typos don't get in the way


    how good would it be to update controlC with a Close Button on frmConvert
    Is this possible?
    Thanks

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Sure

    Forms!TargetFormName.TextboxName = Forms!SourceFormName.TextboxName
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    libraccess's Avatar
    libraccess is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Napier New Zealand
    Posts
    129
    Does a wino moderator prevent me from drinking too much Sauvignon Blanc?
    OK cool I tried the code on the text box afterupdate but no go so OnClose gave me the desired results

    THANKYOU
    I'll go back to my pinot gris

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    No, you can drink all the Sauvignon Blanc you want. However, nice Cabernet's will have to be confiscated or at least shared.

    It should have worked in the after update event, but glad you got it sorted out.
    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. Calculated field for table not form
    By cheyanne in forum Access
    Replies: 1
    Last Post: 01-27-2012, 07:29 AM
  2. Replies: 5
    Last Post: 09-09-2011, 01:15 PM
  3. Calculated control help
    By cici in forum Forms
    Replies: 4
    Last Post: 05-16-2010, 12:04 AM
  4. Calculated Field in continuous form
    By doobybug in forum Forms
    Replies: 2
    Last Post: 11-15-2009, 08:54 AM
  5. Update table from calculated field in a form
    By BernardKane in forum Forms
    Replies: 3
    Last Post: 11-28-2006, 09:48 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