Update Table Value Based Upon Form Entry

  • Thread starter Thread starter pschmuckie
  • Start date Start date
P

pschmuckie

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
received.

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")
 
Back
Top