Recent content by RickCaird

On Current does not fire on initial load. My current solution (which I don't really like) is to issue the same query on the main form load and get my own totals from that. Now, I will just have to make sure that I update those totals when a transaction is updated or added. Rick

I am developing a classic order/detail kind of application. The twist is that I need program control to sum the detail records. Based on the year of the transation, I need to put things into different buckets. What I need is an "On CURRENT" type of event while the form is loading the...

Never mind, I found the problem. I had the form bound to the table. I just took the binding off and I am no longer getting those duplicate records.

My client wants a data entry application, but he wants the previously entered data to remain on the screen since he usually only wants to change a couple of the data fields. So, I created a form (.mdb) and add the record via vba code. I have the autonum field turned on and have set the form...