Access forms/subforms

Hi Adele

Thank you for your question

I am assuming that you have built the subform using the wizards. If this is so, then you might well be better using a variation of the technique we covered on the VBA course.

Create an SQL string based upon the required time sheet information.

You will have to create a series of variables, set their values equal to the values of controls on the main form. You will then have to embed them into an SQL string.

You can then set the control source of the subform to that string.

If the recordset is empty, then you could simply set a condition to hide the sub form.

Hope this is helpful, if it doesn't work please get
back in touch

Regards

Stephen