Triggering Event

[wes9659]

I hope I explain this so someone may understand I apologize for the non-tech words. I have developed an Access 2013 database, which has grown as I am learning the many facets of Access. The database I will use at work in a funeral home. I Have one combo box field that is named Category with three selections those being Prearrangement, At Need, Infant Stillborn. Prearrangement is my default value which is perfect until the actual death occurs. It is on a form named Personal Info. The other is a date field DOD (Date of Death) which is on form named Vital Statistics. Both forms are ultimately subforms of navigation form named funeral record. All data is stored in table named Primary_Data_Table. What I would like to do is figure out how to make that combo box Prearrangement field switch automatically to At Need once the date field is triggered. However, I also would like to be able to manually select Infant Still born from Combo box as needed. Does anyone know if this is possible and how I would implement this? Thanks everyone for all your help I have learned so much from these forums.

[orange]

It is important to get your tables and relationships designed to mee t your requirements before getting into forms and queries.
Do you have a data model? Can you post a jpg of it?
Here is a free, generic funeral home data model that may help with your data structure.

Good luck.

Related reference materials/videos.

[wes9659]

Things seem to be working as I like with the exception of I am trying to figure out how to write the event. I have Category field now hidden on Vital Statistics Form so I am trying to figure out how I would write it to trigger on change event code which would replace the Prearrangement choice with At Need

[wes9659]

and still allow manual selection override for Infant Stillborn