Results 1 to 2 of 2
  1. #1
    Turncloud is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jul 2013
    Posts
    22

    newbie post - why can't I update a field from openargs

    I am trying to open a new form with an addnew command, pulling a value from the previous form (linked to a seperate table) using openargs.
    The open args bit is working as I've inserted a msgbox(ref) line and it shows the correct figure.

    This is the form_open code



    Click image for larger version. 

Name:	snip1.JPG 
Views:	10 
Size:	18.1 KB 
ID:	13717

    I get a 2448 error - You cannot assign a value to this object. Reference is a field in the table rather than a control on the form.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The Open Event of a Form is too early in the process to reference a Control on the Form. Use the Load Event!

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

Similar Threads

  1. Replies: 4
    Last Post: 07-28-2013, 12:40 AM
  2. Replies: 5
    Last Post: 01-27-2013, 06:04 PM
  3. Replies: 2
    Last Post: 06-05-2012, 12:33 PM
  4. How to set openargs of sub report?
    By flippedbeyond in forum Programming
    Replies: 11
    Last Post: 09-20-2011, 08:24 PM
  5. Showing OpenArgs in a Report.
    By SIGMA248 in forum Programming
    Replies: 2
    Last Post: 04-01-2011, 11:57 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