Update Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field Subtotal in a query1. Now I want to update this field into the table. How can I do it?
Thanks,
 
<<
I have a field Subtotal in a query1. Now I want to update this field into the
table. How can I do it?
Thanks,[/QUOTE][/QUOTE]

Well instead of having a calculated control on the form which can't be bound to
the underlying table or query, perhaps have code behind the form perhaps a
function that is triggered by the AfterUpdate of certain fields on the form
which puts the proper subtotal into a bound control.

Best regards,
J. Paul Schmidt, Freelance Access and ASP Developer
www.Bullschmidt.com/Access - Sample Access Database
www.Bullschmidt.com/login.asp - Web Database Demo
 
Back
Top