*resolvaed*trigger

[Ljubisa]

can I create trigger on MS Access database,

for example I want to edit rekord Field "Name" ,but first i want to check if already exist that value in rekord field "Name",
except that who I want to edit if rekord.field stay unchanged......

[peet]

what are you asking here ?

please refphrase and elaborate

[ns-code]

Ljubisa, nauci malo engleskog, a ovo i da si mi reko na srpskom tesko da bih razumeo

[peet]

ja det var jo enda klarere

[Ljubisa]

Ok ,my question is really confusing I apologize (I'm not sure that I understand if I read it in the forum).......When I edit a recordset I want to check if there another recordset with same value.......

is there another goor method except
rekord.Open " select * from employees where name = '" & name.Text & "',connection,vbOpenStatic,vbLockReadOnly

if rekord.recordcount > 0 then..................etc.....

[Ljubisa]

By the way,
can be trigger created on MS Access database..............


Thanks.....................

[Ljubisa]

I solve my problem.........
It was very easy but I didn't explain very well.......
Thanks any way........