Make subform close if query returns 0 records (1 Viewer)

[robina]

Hi,
I have already read this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=13864
It was helpful and closes the form if the query returns no records. My problem is when i use this form as a sub form, it makes the main form close as well. How can I make the main form stay and only the sub form close.

thank you
http://www.access-programmers.co.uk/forums/showthread.php?t=13864

 

[bob fitz]

Instead of closing, you could set the sub form's Visible property to False

 

[robina]

bob,
I agree, that would be great. I tried but believe I had the wrong syntax to refer to the actual subform vs. a control. Can you tell me the code?

 

[bob fitz]

Try:
Me.NameOfSubFormControl.Visible = False
You will need to substitute the name of the name of the control (the bit in red). Keep in mind that a Subform control's "Name" property is not always the same as the actual form name.

 

[robina]

I appreciate the quick response. I need to make the entire subform invisible, not any certain control.

 

[bob fitz]

I appreciate the quick response. I need to make the entire subform invisible, not any certain control.

Yes,I know, but the Subform is a control of the main form and has it's own properties, just as textbox is a control with it's properties.

 

[robina]

Okay, I got it to work. this is what I have in the load event of the subform:

If Me.RecordsetClone.RecordCount = 0 Then
        Me.Visible = False