I have a small form that I use to create a report every month. Some of the information in those field carries on every month but other fields change each month. How can I have just certain field cleared of the information without deleating the entire record? Can a query update a field with an "Null" value. Or can this be done through VB? I just want the clear informatin in certain fields of a record and keep others.

Sandrao

I'm not sure if I understand you completely, but let's see.

You have some fields where you want to clear the information from previous reports, other fields where you want to keep previoius among with current data, right?

If that is the case, there's a couple ways to do it.

If you're displaying the data in listboxes, you can set each individual listbox's rowsource, so some will collect total data, other only for current data. Same thing can be accomplished with subreport's recordsource if you need to display in a continous form or something like that.

This is most reliable and easiest solution to do, IMO. But if you really can't do that (and have a good reason not to do the above), you could use Tag property of each field (in Other tab on the properties window) to identify which fields you want to clear out data and use VBA to loop through the fields on the report and clear out the data whenever it comes across a field with the Tag filled in.