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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Command button to look up and copy data from a query to a table 0
DSum update query with multiple fields 0
#Name? error on form 9
Make query headings just contain field names? 1
Sumproductlike in Access 1
Update Query 3
SQL Syntax 5

Back
Top