Updating a table

[alpine82]

I have 2 tables and need to update fields in one table with values entered in a 2nd table. i.e., i have a transaction form that logs items IN or OUT of a location and datestamps the transaction. when this occurs, i need to update a location and date field in another table (Asset Table). I am having lots of trouble getting this to occur. Any suggestions? I have tried macros, but keep getting various Jet Access errors. Thanks for any assistance!

 

[dcx693]

Check out these links:
Updating a Table from a Second Table Using an Expression
How to Update a Table Based on Values in a Second Table
Updating and Appending Records in One Update Query

 

[alpine82]

Links don't work

I tried all three links, but they all just bring me to a page advertising a pop-up blocker!

 

[dcx693]

Oops, sorry about that. Try these now:
Updating a Table from a Second Table Using an Expression
How to Update a Table Based on Values in a Second Table
Updating and Appending Records in One Update Query

 

[alpine82]

query

Is there any other way to do it without having to use an update query?

 

[Pat Hartman]

you can use the update method to update either a DAO or ADO recordset.