scoop10000
New member
- Local time
- Today, 02:25
- Joined
- Aug 19, 2004
- Messages
- 9
I'm running Access 2003 split front end/ backend. I have been programming with access for about a year and was advised to use ADO. I have a form frmOrderEntry with a subform frmOrderDetail. The FrmOrderEntry contains the customer details and is unbound and populated via ADO. The frmOrderEntry is where the problem occurs. I populate the main form with the customer details and enter frmOrderDetail - this is a form whose record source is an empty table. I enter the productNumber, quantity and events fill out the description and salesPrice. After leaving salesPrice it moves to the next record for input. When I've completed the orders I leave the subform manually and enter the main form filling in a few extra details. I then hit the save button which saves the order details to my main files. After this I delete all the entries in the table and Requery the subform. I then follow the same procedure for different customers.
This is where the problem occurs as occasionally the fields on the subform are filled with #Error. I recently removed the Requery to see what would happen and was surprised to see that there seems also to be a delay in the subform updating. What I mean by this is that everything appears to have happened correctly on the save button, but the records on the subform could take up to 5 seconds to disapear off the screen. I am convinced it is this delay that causes the problem as please remember the problem never happens during the first customer order entry. Everything else in my programme is working well so if I can resolve this I'd be very happy. I hope the above is not too detailed or confusing and would appreciate any help or suggestions in dealing with this or maybe just adopting a different approach?
This is where the problem occurs as occasionally the fields on the subform are filled with #Error. I recently removed the Requery to see what would happen and was surprised to see that there seems also to be a delay in the subform updating. What I mean by this is that everything appears to have happened correctly on the save button, but the records on the subform could take up to 5 seconds to disapear off the screen. I am convinced it is this delay that causes the problem as please remember the problem never happens during the first customer order entry. Everything else in my programme is working well so if I can resolve this I'd be very happy. I hope the above is not too detailed or confusing and would appreciate any help or suggestions in dealing with this or maybe just adopting a different approach?
