code to update another open form

G

Guest

Can you tell me how to write code for the following;
after update
I Have a service application for my business. One form "frmCustomers" has a
button to open another form frmCustomersEquipment" which has a button to open
"frmRepairs".
frmCustomers is related 1 to many to frmCustomersEquipment and
frmCustomersEquipment is related 1 to many to frmRepairs.

While I am in frmRepairs and frmCustomerEquipment is also open.
I have a checkBox field to indicate if this is a "preventative maintenance"
(named "PM") type of repair.
and I have a DateCompleted field.

if PM= true and DateCompleted is not null then
update the field in frmCustomerEquipment called LastPMDate with the
date in frmRepairs 'DateCompleted
I am not very good at code and would appreciate your help


Thank you, Keith Gervais
 

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

Similar Threads

need to update another open form 1
need to update an open form from another Write code 1
Update form with newly added data 1
cancel changes on subform 2
Update Queries and Record Locks 3
using additional form in continuous form 6
Action on one form to cause action on another 2
Multiple filters 1

Top