Update Table Value Based Upon Form Entry



I have two tables 1) vendor list and 2) Financial Data...
The vendor list holds the vendors information, the financial data houses
certain key information from the vendors financials for each quarter.

As I update the form that populates the financial data with the financial
statement date 1Q10 (First quarter 2010) I want Access to update the vendor
list table to indicate that the 1Q financial statement has been received.
Essentially, need access to CLICK the box indicating the statements have been

Any ideas on how to make that happen? I've tried default values and update
queries but neither of those will work.




Build an update query to update the fileds you want. Then put a command
button on your from and go to the onclick event in properties. Start the code
builder and type Currentdb.execute ("name of your query")

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