Recent content by bockmj18

Thanks for the upload, but I can't open it as I'm working off of Access 2000. HOWEVER, I did fix it with some SQL. Because the Append Query wasn't pointing to a specfic record for it to Append to, it was cycling. All I needed to do was to tell it where to write using the WHERE My Append...

I think you can upload it to the thread unless you have protected info that you don't want out to the public

Sure, I can do that. I did some more digging online and I'm getting mixed answers saying that adding criteria to the Append Query could remedy it, along with your suggestion to look at table/query relationships, as well as modifying the SQL

Thank You for the help! It's working to a point, but there's still something wrong with it. I added the VBA to the button and the Append Query is working as it's supposed to now, but when I click on it and the Comments subform requeries/refreshes, it has appended 444 new records (which is...

hopefully this isn't too out of date, but I'm trying to do the exact same thing but I can't get it working properly. Anyway you could help me out with how you solved yours? When I run the Append Query, it's trying to append ALL records instead of just the data typed into the unbound textbox...