Invisible subforms

[benjee]

Good morning,

Basically i have two forms 'Customer' and 'Job', a user can create a new job in the job form via a subform.

Now there is also a subform in the customer form that displays all jobs for that particular customer.

If a customer has NO jobs is there any way of making the customer subform invisible until a job is created?

regards

 

[Mile-O]

You can set the subform's Visible property to No.

 

[benjee]

Hi,

that doesn't work, when i create a new job in the 'job form' the subform in the 'customer form' doesn't appear/update if i set visible to No.

 

[Vassago]

In the event procedure of where they type in a new job, place code to make the subform visible again.

 

[benjee]

Hi Vassago,

Im not entirely sure how to do it.

In the JobNo field would i need to use the SysCmd to test whether a form is open and then add code to the On Open property?