I want to put a button to run a report on the child form but I only want to use it when I open the child form alone (that is, not as a subform).

Anything I add shows on the parent form or causes the scroll bar to show up if I try to shrink the window to hide what I do not want to print.  Maybe I can make it invisible only when viewed as a subform?

Also, can you have info from subform sent to parent under any circumstances? (I found FormFieldValue but that apparently only works the other way. i.e. info from parent to child.)

(Sorry if these are too simple or obvious questions. I can not think thru the cold medicine very well.)

Thanx
~Natalie

I use two forms to do that.

Make a form with all elements, visible, and then make a copy.  On the copy, make the unwanted fields invisible, and use that form as the subform.  The copy probably does not need any programming and could have all fields ReadOnly so you don't corrupt the programmed data in the Parent/Subform relationships.

Now you can use either of the subdatabase forms for Searches of the database at the subform level vs Searching at the parent form level.

===========================
But I like Ray's method.  I don't recall the StandAlone function., but that sounds like a good option to do the same thing.  Will have to check and see when that functions slipped in......

Hi Natalie......

Only the President is allowed to call him Mister Hansen.

Your friend,
BOB