How to delete row...

[ires]

I have created a table in Access to track data for a MealsOnWheels program.

The table needs updating daily--particularly the column named "Stopped".

I need direction on how to create a macro that would automatically delete a row after the user manually makes null a field in the "Stopped" column.

I would appreciate any direction I can get.

Gracias! Ires iwnj@aol.com

 

[PHV]

Take a look at the DoCmd.RunSQL method and the DELETE FROM SQL instruction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244