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