Form Update Alternate Record

[LadyDi]

Is it possible to update one record on a table from another record in a form?

I have a form that tracks orders. It shows if one order is replacing another. If it is, the database checks to see if the old order needs cancelled. If it does, a message appears on the screen letting the user know that the old order needs cancelled. Is there a way for the database to enter a date in the cancellation field of the old order while on the record for the new order? That way, I would be able to run a report detailing the orders that need cancelled.

Any assistance you can provide would be greatly appreciated.

 

[pbaldy]

Sure, you can open a recordset using the old order number as a criteria, or run an update query with similar criteria.