Hi,
I have a grid with 3 radio buttons and a 3 Date and Entered By fields. When a user makes a selection in radio_button_1(Stat1), i update the Date and Entered By field with the users name value. When a user makes a selection in radio_button_2(Stat2), i update the Date2 and Entered By2 field with the users name value.and so on....
The problem with the code i am using is that if a 'different user' selects one of the radio buttons, 'all' the Date and Entered By fields change to the current user and current date. I need to prevent them from changing if its specific radio button remains unchanged.
Is there a command i can place in my code that will only update the radio button related fields only and leave the related untouched radio button fields alone?
Thanks,
Denis
I have a grid with 3 radio buttons and a 3 Date and Entered By fields. When a user makes a selection in radio_button_1(Stat1), i update the Date and Entered By field with the users name value. When a user makes a selection in radio_button_2(Stat2), i update the Date2 and Entered By2 field with the users name value.and so on....
The problem with the code i am using is that if a 'different user' selects one of the radio buttons, 'all' the Date and Entered By fields change to the current user and current date. I need to prevent them from changing if its specific radio button remains unchanged.
Code:
select case DataSubmitted.Stat1="No" DataSubmitted.Date1="" DataSubmitted.Entered_by1="" case DataSubmitted.Stat1 ="Yes" DataSubmitted.Date1=date() DataSubmitted.Entered_by1=session.__protected__metUserName end select select case DataSubmitted.Stat2="No" DataSubmitted.Date2="" DataSubmitted.Entered_by2="" case DataSubmitted.Stat2 ="Yes" DataSubmitted.Date2=date() DataSubmitted.Entered_by2=session.__protected__metUserName end select select case DataSubmitted.Stat3="No" DataSubmitted.Date3="" DataSubmitted.Entered_by3="" case DataSubmitted.Stat3 ="Yes" DataSubmitted.Date3=date() DataSubmitted.Entered_by3=session.__protected__metUserName end select
Thanks,
Denis
Comment