Jonathan Kok
Registered User.
- Local time
- Today, 15:00
- Joined
- Jan 27, 2000
- Messages
- 116
Good day all,
I'm developing a Purchase Order database for my company. I've run into a bit of a problem. The form I'm working on is the actual Purchase Order Entry form--you can imagine what it looks like. The difficulty I'm having is that on the Ordered Items subform, (where the user enters in the ordered items, oddly enough), I have a calculated total of how many items were ordered, and another calculated total of how many were received. On the parent form, I refer to these two totals in the On Current event for the Form in order to check if all of the ordered items were received. Unfortunately, the fields aren't updated until after the On Current event occurs (although, if I insert breakpoints in the code where it checks these, it works properly so it might just be that it doesn't calculate the totals fast enough). The code returns null values. After the code has run, and I look at the totals myself, they appear as they should. Is there any way to get this to work? I'm using Access 2000, if that makes any difference.
Thanks,
Jonathan Kok
I'm developing a Purchase Order database for my company. I've run into a bit of a problem. The form I'm working on is the actual Purchase Order Entry form--you can imagine what it looks like. The difficulty I'm having is that on the Ordered Items subform, (where the user enters in the ordered items, oddly enough), I have a calculated total of how many items were ordered, and another calculated total of how many were received. On the parent form, I refer to these two totals in the On Current event for the Form in order to check if all of the ordered items were received. Unfortunately, the fields aren't updated until after the On Current event occurs (although, if I insert breakpoints in the code where it checks these, it works properly so it might just be that it doesn't calculate the totals fast enough). The code returns null values. After the code has run, and I look at the totals myself, they appear as they should. Is there any way to get this to work? I'm using Access 2000, if that makes any difference.
Thanks,
Jonathan Kok
