Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If no record in a subform then subform not visible

Status
Not open for further replies.
fludan

fludan

Technical User
Feb 1, 2002
41
0
0
US
Hi
I have a form with 3 subform, if subform1 as no data I would like the subform1 the be hide. For subform2 and 3 the same ting.

Thank
Frank
 
Sort by date Sort by votes
Select one field in each of the subforms that need to be populated for you to want it to be visible and enter in the OnCurrent event:
If IsNull(SelectedFieldName) Then
Me.SubForm1Name.Visible = False
Else
Me.SubForm1Name.Visible = True
End if
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
493
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
164
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
109
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
119
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Duplicate Records in DataSheet View
Replies
5
Views
117
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top