need to update an open form from another Write code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Rich,
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
 
Back
Top