E
Enzo Diana
I am working on a database which has several linked tables with one to many
relationships. When adding a newrecord I use code to add the record and also
to seed the associated tables with relevant Linking Info (such as CustID
etc).
For example I get the user to input the new Customer name using the Input
command and after adding the record in the main table I populate relevant
associated tables with the CustID etc. The user then can add data to the
tables via a number of different forms This all works very well except
using the Requery command appears only sometimes works. I have added Requery
to relavant parts of my code including On Open , On Close properteries of
associated forms. It appears as theres a timing problem, as if I wait a few
seconds and/or use Shift F9 a few times the new records appear. Anyone have
any ideas? The frustration factor is building!
relationships. When adding a newrecord I use code to add the record and also
to seed the associated tables with relevant Linking Info (such as CustID
etc).
For example I get the user to input the new Customer name using the Input
command and after adding the record in the main table I populate relevant
associated tables with the CustID etc. The user then can add data to the
tables via a number of different forms This all works very well except
using the Requery command appears only sometimes works. I have added Requery
to relavant parts of my code including On Open , On Close properteries of
associated forms. It appears as theres a timing problem, as if I wait a few
seconds and/or use Shift F9 a few times the new records appear. Anyone have
any ideas? The frustration factor is building!