Conditional Format Recordcount

[Gannet]

I have a subform on a tab control. I want to add a text box that will be unseen by the user when there are records in the subform but visible when there are no records displaying "No Records Found". I want to do this by using Conditional formatting by having formatting blend into the page unless a condition is met then it will change the Fore color to Red. I've used the code:

Forms![frmSubjectInfo]![sbfrmAE].Form.Recordset.RecordCount=0

to determine if the subform recordcount is 0. It works fine when testing in a messagebox but doesn't work in the conditional format expression.

 

[Alansidman]

Are you trying this with VBA or are you using the Conditional Formatting option available in design mode?

Alan

 

[Gannet]

Whoops, I thought I had already posted a reply.

I'm using the conditional formatting in design view.

 

[Gannet]

Is there no one who knows the answer to this?