Form from 1 DB updates table in another DB

[jminn0311]

I have a form that is used to take equipment out of service. There is a combobox that is populated from a link to the equipment database. There is a checkbox for out of service. When a piece of equipment is selected out of service in the first DB i need to make sure that the table in the second db is updated also. Anyone have a solution to this dilemma?

Thank you,

Jeff Minnick

 

[PHV]

You may consider an update query in the AfterUpdate event procedure of the checkbox.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244