Can I create a query to display within my form

[Steven.Ashby82]

Hi All,

I'd like to have a text box (locked) in form view that can give me a live status on how many forms contain "open" within there field is this possible?

 

[John Big Booty]

Hi All,

I'd like to have a text box (locked) in form view that can give me a live status on how many forms contain "open" within there field is this possible?

If the Purple highlighted word should have been fields, you could use the DCount() function to populate your text box.

 

[Steven.Ashby82]

Thank you, but how do I input that function into the textbox? Sorry I'm having a really bad access block day today

 

[John Big Booty]

Simply put it in the Control Source of your Text Box;

=DCount ( "YourFiledName", "YourTableName", "YourFiledName = 'Open'" )