HeadAgainstABrickWall2021
Member
- Local time
- Today, 12:23
- Joined
- Sep 23, 2021
- Messages
- 32
Hi all, quick brief: three tables with respective forms, Customers, Case, Events. One customer can have many cases, one case can have many events.
My issue is how to reflect cases as closed once the last event stage is entered. I had a wonderfully functional update query which was running perfectly, but I'm not able to run this at work due to IT settings in Microsoft Trust Centre which I cant change.
In the meantime, I have tried to set up a subform in the Events form that expands out on clicking 'Update case status'. The problem is that this is trying to change the tblCase.CaseID (autonumber PK). I dont want it to change any data other than tblCase.Casestatus_status ("open" or "close"), tblCase.Casestatus_closedate (date) and tblCase.Casestatus_closereason ("completed request", "unable to assist", "declined-agency" and "declined-customer").
I would also be happy to open another form, if I can call the CaseID from the previous form window and link it automatically?
Any suggestions would be great, I'm a smidge past my understanding here!
My issue is how to reflect cases as closed once the last event stage is entered. I had a wonderfully functional update query which was running perfectly, but I'm not able to run this at work due to IT settings in Microsoft Trust Centre which I cant change.
In the meantime, I have tried to set up a subform in the Events form that expands out on clicking 'Update case status'. The problem is that this is trying to change the tblCase.CaseID (autonumber PK). I dont want it to change any data other than tblCase.Casestatus_status ("open" or "close"), tblCase.Casestatus_closedate (date) and tblCase.Casestatus_closereason ("completed request", "unable to assist", "declined-agency" and "declined-customer").
I would also be happy to open another form, if I can call the CaseID from the previous form window and link it automatically?
Any suggestions would be great, I'm a smidge past my understanding here!