SQLTeam.com | Weblogs | Forums

SQL SERVER Triggers + MS-ACCESS FORMS

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

Nico