Hello to all
My application is a front end Access application linked with SQL SERVER database
I have a Form in Access for the Commands table and a sub form for command lines table
In the CommandLines Table, there is a trigger which calculate the total sum (Quantity x unit price) and more
The "funny" thing, in access, when a create a new command, i cannot modify the Command table, because the database and access have not the same data.
So when i make a me.requery after the process of new command creation, the me.requery put me to a new record.
This is not happening when i modify this command.
I try many things but i can't get it working to keep the cirrent record with a new command
any idea will be welcome