Delete data in Tables using VBA from a Form

[uipuih]

I am using a form with a subform to enter data into two tables:

Table1 Fields: 1)EMPID and 2)CurrentDate (fields are the primary key fields in Table1).
TBLWeekDetail fields: 1)EMPID 2)CurrentDate 3)Activity 4)Organ 5)PreTime 6)Posttime.
I am trying to find a way to allow the user to edit the data at a later time.
I Created another form Form2 where I have two combo boxes so that the user could use the drop down menu to choose their Name and date, the after update event will pull up the original data entry Form and Subform however I am unable to make changes to the data because Access thinks this will cause a duplicate values in the index, primary key or relationship. I have tried to put a delete button on the data entry form but it does not delete the data in the tables.

 

[TheAceMan1]

How are ya New Postuipuih . . .

[blue]I am trying to find a way to allow the user to edit the data at a later time.[/blue]

As far as a later date is concerned ... [purple]whats the difference if a user edits the data at any specific time?[/purple]
[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]