Writing Code

[Incognito]

Could someone assist me in writing code for a subform. I
have a command button, on click - I would like for all the
records to display in the subform. Don't know where to
start. HELP!!

 

[Guest]

You could try something like using a toggle button and the code would be:

if toggle button = updated then
subform.visible=true
else
subform.visible=false
endif

This would hide the whole subform and show it when you click the button. You
need to set the property of the subform to visible = false as a default.

Hope this helps

 

[Guest]

-----Original Message-----
You could try something like using a toggle button and the code would be:

if toggle button = updated then
subform.visible=true
else
subform.visible=false
endif

This would hide the whole subform and show it when you click the button. You
need to set the property of the subform to visible = false as a default.

Hope this helps


.
New to this and not sure if I am on the right track, but

this is what I did and it is not working. By the way,
thanks for the quick response. See code:
If Toggle45 = Update Then
tblExclude_Error subform.Visible = True
Else
tblExclude_Error subform.Visible = False
End If

End Sub

 

[Guest]

I think the code should be updated and not update. Otherwise I cannot see
anything wrong. Sorry