How to delete certain field within form?

[latestgood]

Hello,

I am trying to duplicate a record from form but I wanted to delete certain record (eg. dates, amounts). Is there any docommand I can use to delete certain field?



Thank you,

[Rod]

You have a form displaying a record. You wish to duplicate some but not all of this record? What do you mean by 'duplicate?' Where is this diminished record to be stored/displayed? Do you want to do this for a single record, a selection of records or all records?

There is no DoCmd method that I know of that comes anywhere near this requirement. However depending upon your answers, SQL might be the way to go.