I'm a moderator for this topic. I've been working hard to find a Professional to assist you with your Access 2010 Database , but sometimes finding the right Professional can take a little longer than expected.
I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.
Yes, i can wait. Thank-you.
create a table that has the keys that you scan in from the barcode reader link that to the primary key of the table with the fields you want to change run a modify query to change the fields. setting them to true false and true. As long as its based on the primary key in the first file only those records that match should be effected.
I was hoping to get help, (step -step), with the Query I guess. I've created a new table with just the one field (primary key) and linked it to the other (main) table. I've started the query wizard, but don't see any option for a "Modify Query". Thanks!