Clear records off of continuous form

[Ashe]

Hi!
I’m trying to find a command to clear all the records on a continuous form that were called up using a strWhere Filter and combo boxes.



There are four unbound combo-boxes in the header that the user can choose from and then I have a command button coded to filter (Me.FilterOn) for those criteria.


The matching records display in the details section of the form (continuous-style).



Is there a command to reset the details section of the form to be blank? I’ve tried refresh, requery, repaint, etc. All of these leave the previously queried data. Removing the filter doesn’t work because that display all the records. I basically want the form to look exactly the way it did when it was first opened.


Thank you in advance.

[NTC]

well you are swimming against the conceptual stream - so to speak.

A form is bound to its record source. It is not really intended that one would have a screen of multiple blank records. Only 1.

If you really need this visual approach - then perhaps an unbound form (not continuous - but fixed set up to sort of look continuous - but can't be infinite) with an AppendQuery to add the data. Kind of a kludge though....

Hope this helps a little.

[Ashe]

Oye! I'll have to mull this one over for a bit. Thanks!