Show/Hide Page Control

[RLJ]

Hi,



I am working on a form that will give loan details from a table (tblLoans). On this form, I have a subform on a Tab Control (sfrmIssues) that is linked to a table (tblIssues)

The tblIssues has a foreign key from tblLoans on a one to many (one tblLoans; many tblIssues).

I want to hide the Tab Control (sfrmIssues) if there is not a related record(s) in the tblIssues.

I have done some Excel VBA programming but am new to the Access Programming.

Thanks for your help.

[RLJ]

I need to make an update to my statement above.

The subform is based upon a Query (qryIssuesForLoanDetail). This query is used to filter out resolved issues and only show active issues. I only want to see any acive issues on the Tab Control (sfrmIssues) if there are any "Active" issues based upon this Query (qryIssuesForLoanDetail).

Thanks