Search results

Works Excellent! I appreciate the help. After a little more searching, I figured out how to use the rst.Edit command to *ahem* EDIT the existing data. :D Wheee! All done. Thanks!

More... I could probably use DCount and DLookup to find the date, but how would I then grab the value TOTAL ACRES value associated with the DATE, and put it into a variable so I could then calculate the new ACREAGE value with the then TOTAL ACRES value? Lets try pseudo code if I'm still not...

[RESOLVED] If Prim. Key Exist - How to Update?? Hello all. I'm trying to finish up a database for our farm and am running into issues as I'm pretty new to Access. I know VB6 but not a lot of VBA. We spray chemicals, and need to keep track of the acerage we spray for the date. So here's my...