This works better. I have a subform that does not show when the main form is opened until there are records to populate the subform.
This is what I have in my cmdGo (which is the name of my Go button)
after I have checked to see if there will be any records returned from the value I put in an...