Duplicate Recordset

[shahmananj]

I Want To Prevent Duplicate Record In Form Using Vb6 I Have Four Field Date, Intime, Outtime And Name I Want To Prevent Duplicate Record By Checking Date And Name.... HELP ME IN THE SAME

[debasisdas]

Can you post the query that you are working on.

[QVeen72]

Hi,

Before adding/Inserting a new record, Query the Table for the combination.. If no Records Found, then add new..
You can also Create a Composite Primary key based on "Name+Date"
So table itself will not allow you to add new record. (here you need to code with proper error-handling)

Regards
Veena