From post above:
So the button is on the form I want to close...
The name of the form is "ProdSrchFRM"...
The code I have fails on the DoCmd.Close - what on earth am I doing wrongggggg
Also not sure where that line should be to allow the Else bit to do it's bit...
Okay, got the thing to work but have 1 (hopefully) SMALL problem...
I need to use VBA on click of a button to do it - But I had been using that button to close the form via a macro.
I hate to admit this but I have NEVER (despite trying) managed to close a form using VBA.
So the button is on the...
Hey I think it's his hobby - no hassle - Thank you for the naming conventions & hints n tips - working on it now (arghhh!)
I'll let you know if I get there :)
No idea what or where the Query GUI is - giving up for now ... got to pull user instructions together - they'll just have to put up with my inadequacies :-)
I'm still doing something wrong - If you have a main form (which is not involved at this point), a subform & a sub sub form (which is in datasheet view & which has an unbound combo box filtering it) how would you get the current record selected in the sub sub form datasheet to the sub form in...