Subform Border not Cooperating!

[Turbo]

I have a subform that displays various search results. If the result is null the the subform is set to "Me.sfrmX.Visible = False". This works perfect until a result is not null. Any search following a not null result, the subform is not visible but the border is visible. I have to close and reopen the form to make the border go away.

Any ideas?

Turbo

"There is a fine line between confidence and conceit"

 

[sillysod]

does the subform have a border set up in the main form?

you could take that away and set the border on the actualu subform

 

[Turbo]

Thanks for the reply. I was unable to get the idea you presented to work, but you got me thinking in another direction.

I set the border of the subform to transparent then I placed a box with a black border and transparent back style around it. I set the visible property to false. I set the border visible property to true or false with code based on the search options selected by the user.

"Me.boxX.Visible = True" or "Me.boxX.Visible = False"

Thanks again,

Turbo

"There is a fine line between confidence and conceit"

 

[Turbo]

I found the solution. I did not have the visible property of the subform set to "No". Once I made the default visible property "No" the border goes away when the "Me.sfrmX.Visible = False" code is run.


Turbo

"There is a fine line between confidence and conceit"