G
Guest
Hi everyone,
I have a form called students, in which there is a field called 'SName',
when the user fills in a value a function is called that checks to see if
other fields in the form are filled in and if they are this value is used to
create a student Reference which acts as my primary key. I called this
function from the AfterUpdate property but what i need is to call it only if
the fields value has been changed, not if a new value is being inserted.
I was thinking of using the me.newrecord property to check if it was a
newrecord and acting accordingly but is this the way i should be looking at
it, seem clumsy. Any suggestions would be gratfully appreciate.
Amit
I have a form called students, in which there is a field called 'SName',
when the user fills in a value a function is called that checks to see if
other fields in the form are filled in and if they are this value is used to
create a student Reference which acts as my primary key. I called this
function from the AfterUpdate property but what i need is to call it only if
the fields value has been changed, not if a new value is being inserted.
I was thinking of using the me.newrecord property to check if it was a
newrecord and acting accordingly but is this the way i should be looking at
it, seem clumsy. Any suggestions would be gratfully appreciate.
Amit