Sir, thank you very much for the response. I felt by directly displaying the data on the form, the same could be changed inadvertently by my friends/colleagues. Hence, I thought it fit to use recordset and display them on the form, so that the table remains unaltered unless the same is done...
I get error as "the changes you requested to the table were successful because they would create duplicate values in the index, primary key or relationship" when I try to insert a record into local table, details gathered from a form. My exposure to computer programming is only functional and...