Gang,

I'm programmatically modifying the foreground property of some text controls
on a continuous subform for formatting purposes.  When I close the main form
it wants to save both main and subform which I don't want the users to see /
deal with.  I've searched and searched and tried a few ways to force it to
close without saving (including "docmd.close yada, yada, acSaveNo" and some
code involving "DestroyWindow" I found on the MS site) all to no avail.  

Does anyone know how to handle this so that the form closes without saving
and without prompting the user.  The program is running on Access 2007 and
Runtime 2007.  (Symptom occurs on both).

Alternatively, the overall goal that I'm trying to accomplish is put a blank
line in between specific groups in a continuous form.  The formatting I
mention is setting the background and foreground of all the controls to the
same color to fake the "blank" line for some close to empty lines I've got in
the TSQL Procedure.   If anyone has a nice way to make subforms insert blank
lines based on specific data in the query, I could probably use that and
forget the formatting.

Thanks for any help in advanced.