Results 1 to 2 of 2
  1. #1
    mcwillo is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    1

    Command Button to send RecordID to append query?

    Hi, I’m ok with analysing datasets but when it comes to using Access my skills are quite primitive – I’ve tried searching but can’t find exactly what I’m after! If this is a common question please point me towards the correct thread, otherwise I’d really appreciate some direct help



    I have a Continuous Form that displays the data from a make-table query that’s run throughout the day. I have a Command Button called ‘Moved’ on each row against every record. The end requirement is that the user clicks on this button, and the macro will pull the corresponding RecordID to a separate table called ‘Moved’. This appends the RecordID into the corresponding field, and marks the Moved flag as True. The idea is this will get fed back into the Continuous Form and I’ll be able to sort this form by the ‘Moved’ flag so records that have been moved appear at the bottom possibly with conditional formatting.

    Any idea how to do this? I have tried an append query but this doesn't grab the record and I'm left with a blank table. I’m stuck with the basics really, I’m not sure how to grab the RecordID, how to append this into the secondary table and how to force the flag as being True.

    Cheers

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Put the button in the header or footer of the form, not on each record.

    On Button_Click
    Run an append query to move the selected record.
    Run another query to update the "Moved" flag (checkbox?) of the selected record.

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

Similar Threads

  1. how to disable command button
    By archie in forum Access
    Replies: 1
    Last Post: 08-27-2009, 11:11 PM
  2. Command Button Help!
    By arthura in forum Programming
    Replies: 3
    Last Post: 06-30-2009, 12:55 PM
  3. Command button issue
    By sloppysly in forum Forms
    Replies: 8
    Last Post: 06-15-2009, 12:07 PM
  4. Duplicate command button
    By brettg in forum Database Design
    Replies: 1
    Last Post: 08-04-2008, 04:16 AM
  5. Net Send from a button on an Access form
    By Deb4995 in forum Forms
    Replies: 0
    Last Post: 10-19-2006, 10:19 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