Results 1 to 3 of 3
  1. #1
    andrebmsilva is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    19

    Query Update Criteria Continuous Form Row ID

    Hello everyone,

    I have this doubt: What should i write in the criteria of a Query Update so that when I click on the Check-Box of the row, writes something in a field of the this row?
    I've tried using the ID master and sub... but didn´t work. I've tried something like this Criteria: [Forms]![FormName]![rowID]. But so far i couldn't do it.
    What am I missing? I don't understand... Hope someone can help me.



    Thanks,
    André

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Is the checkbox bound to field of form RecordSource? If it is unbound then the same value will show for all rows.

    Is the continuous form a subform on another form?

    Show the complete SQL statement of the query.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    andrebmsilva is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2012
    Posts
    19
    June7 my problem is solved, thank you!

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

Similar Threads

  1. Replies: 5
    Last Post: 09-20-2012, 03:27 PM
  2. Replies: 6
    Last Post: 08-30-2012, 06:23 PM
  3. Replies: 1
    Last Post: 05-18-2012, 11:59 AM
  4. Replies: 1
    Last Post: 03-23-2010, 04:01 PM
  5. Query Criteria Lost After Table Update
    By matt4003 in forum Queries
    Replies: 10
    Last Post: 12-29-2009, 10:50 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