hardik_088
Registered User.
- Local time
- Today, 16:48
- Joined
- May 31, 2011
- Messages
- 82
Hi,
I solved type mismatch error problem but i get new problem while doing that. Here I attach my database . In the "Insert_data" form you try record 20 from laptops table and enter data in this fields date,type,supplier , description,location,department,part number
here if i enter different value in department field then it will insert query but if i enter any different value from table in department then it is still updating record why?
Actually I want to check that if description, location,part number,department is same from record then it should update query if one of them is different then it should insert query.
Thanks a lot
I solved type mismatch error problem but i get new problem while doing that. Here I attach my database . In the "Insert_data" form you try record 20 from laptops table and enter data in this fields date,type,supplier , description,location,department,part number
here if i enter different value in department field then it will insert query but if i enter any different value from table in department then it is still updating record why?
Actually I want to check that if description, location,part number,department is same from record then it should update query if one of them is different then it should insert query.
Thanks a lot