Insert new record when condition is met

[scoobyroo]

I have a table called MonthlyData with the following columns:

Name Date Prelim Received All Received Comments



I also have a form that the user inputs data into. If they select "No" for the All Received column, I need the current record to be copied and inserted
into the table, but only with the name populated.

Example

John Smith 8/5/2008 N Still waiting on 2 prelims
John Smith


I am not sure what the best way to do this would be. Any help would be appreciated.

 

[PHV]

Use an append query (INSERT INTO ...)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886