Hi,
I have created a database for my workplace. It stores suppliers, customers, parts, quotes, projects, parts lists etc. The database works very well but I have one bug which I am not sure how to solve.
Sometimes when amending a value in a record (in this case on the parts form), the value that i put in, 'access' puts the value in the previous record in the dataset. It is very irritating! It is like it copies the value you are trying to enter and puts it in the same field but in the next record along so you end up amending another record. It only seems to happen if the form is opened from a certain place in the database. You may think that I have put some code in to copy and paste data or something like that but I can be sure that this is not the case. The form is quite simple and I think it is a bug in Access 2000.
Any ideas?
Thanks,
Chazney.