Checking for an Empty SubForm

S

Sharkbyte

I have a screen w/ 2 subforms. When the form is first opened subform1 has no
date, and displays as blank. Subform2 has several controls, and buttons, and
some of the buttons should respond differently based on whether subform1 is
blank or displays data. What is the code to check whether or not subform1
has or is displaying data?

I was trying something like:

If IsEmpty(subfrmTechnicianWorkbench1) Then

But this always returns True.

If I try:

If IsEmpty([forms]![frmtechnicianworkbench]![subfrmTechnicianWorkbench1]) Then

It always returns False.

All help is definitely appreciated.

TIA

Sharkbyte
 
B

Brett Stone

I believe "Me!sfrmcontrol.Form.RecordsetClone.RecordCount" should tell you
how many records behind the form. If it is zero then...
-Brett
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display 0 in a textbox that obtains a null value from a subform 6
How to always get the top level form reference, when calling from any subform/subform... 0
Modifying/Appending records between subforms 2
Syntax for Refreshing Control on Sub-Subform 6
Cancel the changing to a different record in a subform 1
A2002: Subform's subform's RecordSource 6
Referencing Data in One Subform From Another Subform? 2
ApplyFilter event on a subform 1

Top