In fact, there are two issues with the same logics behind. Hopefully, there will be no problem for Access Monsters:
There is a form based on the table. It has field [Due_Date] and it has field [Status]. Field [Status] is actually a combo box (2 colums: 1st p-key hidden; 2-nd text visible= "Outstanding" or "Closed".
Algorythm: If Combo is "Outstanding" then [Due_Date] can be whatever date or even empty.
If Combo is "Closed" then I want to be sure that the due date will be deleted automatically. Means, I need the field empty (not zero but empty). (people do forget to delete due date during closing of the case=> leading to closed case appears with due dates on the cumulative status etc.
Thanks in advance,
Question 2 is mostly similar:
Another table- another form. There is the same combo and 2 tick boxes.
Combo=" oustanding"=> [Tick1] and [Tick2] = whatever selected by the user
Combo="closed"=>[Tick1] and [Tick2]= not true
The code looks pretty simple. Dont understand why its not working.
Can split in two separate questions to award more points if necessary. Still dont understand where is the catch with these points (No time).