subform only visible if it contains data 1

[kermit01de]

Scenario:
- Form with Combo-Box - selected "User" will display details in detail section
- subform in detail section that displays the "user" if it is present in another table (SELECT [Fehlende].[User] FROM Fehlende; )

How to hide the subform if it does not contain records/data?

Thank you!



--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<

 

[MajP]

Untested by I would think,

me.subformcontrolName.visible = (me.subformcontrolName.Form.recordsetclone.recordcount > 0)

called from the mainforms on current event and from the combos after update.

 

[kermit01de]

Thank you - that´s what I needed - Great!

--------------------------------------
>>>>>> Bugs will appear in one part of a working program when another 'unrelated' part is modified <<<<<