I have a defect form with a button that opens a sign-off screen. On this signoff screen I have 3 possibilities based on the kind of defect. #1 is the mechanic signs, #2 is a quality inspector sign-off and #3 is a second quality inspector sign-off.
Data from defect and signoff screen come from the same table.
So far all is working perfect. Now I added a new field on my defect screen, master signoff. In this field I need the value from the highest level of signature for this specific defect. So, here's my thoughts : When the signoff screen is closed, this data is saved to my table so the data is available for my defect form (as reference I put a copy of the separate signoff fields on my defect screen to see if they update properly, which they do...)
Now I want to fill my mastersignoff field with the data from let's say the second inspector signoff if this field is not empty. I tried a few things but seem to have syntax problems.
This is more or less what I put in VB :
if Not Isnull (me.secondinspsign) then me.mastersign = me.secondinspsign
Obviously it didn't work, looking in the help file for referencing they said to change the . to !, but this doesn't change a thing. Basically what needs to be done is check if a field is empty, if not then put this value in the mastersign field, otherwise put the value from inspsign if it's not empty and as a default take the value from the mechanicsign.
Can somebody get me in the right direction again ?? I'm starting to mess around and I'm sure in a few hours nothing will be working anymore...
Thanks, Koen
Data from defect and signoff screen come from the same table.
So far all is working perfect. Now I added a new field on my defect screen, master signoff. In this field I need the value from the highest level of signature for this specific defect. So, here's my thoughts : When the signoff screen is closed, this data is saved to my table so the data is available for my defect form (as reference I put a copy of the separate signoff fields on my defect screen to see if they update properly, which they do...)
Now I want to fill my mastersignoff field with the data from let's say the second inspector signoff if this field is not empty. I tried a few things but seem to have syntax problems.
This is more or less what I put in VB :
if Not Isnull (me.secondinspsign) then me.mastersign = me.secondinspsign
Obviously it didn't work, looking in the help file for referencing they said to change the . to !, but this doesn't change a thing. Basically what needs to be done is check if a field is empty, if not then put this value in the mastersign field, otherwise put the value from inspsign if it's not empty and as a default take the value from the mechanicsign.
Can somebody get me in the right direction again ?? I'm starting to mess around and I'm sure in a few hours nothing will be working anymore...
Thanks, Koen
