I have code which currently reads something like:
If Me.Priority = "Urgent" Then
Me.command200.visible = false
Me.command201.visible = false
Me.command202.visible = false
End if
Is it possible to group the command boxes together under a bracket and then have then all = false rather than write them all out individually?
Also I have some code to write for the form.footer to be visible conditionally.
If me.recordset.recordcount < 1 then
Me.formfooter.visible = true
End if
Under what form event would I write this code? I've tried a few and they don't work
(For example form_current)
Thank you very much
If Me.Priority = "Urgent" Then
Me.command200.visible = false
Me.command201.visible = false
Me.command202.visible = false
End if
Is it possible to group the command boxes together under a bracket and then have then all = false rather than write them all out individually?
Also I have some code to write for the form.footer to be visible conditionally.
If me.recordset.recordcount < 1 then
Me.formfooter.visible = true
End if
Under what form event would I write this code? I've tried a few and they don't work
(For example form_current)
Thank you very much
Last edited: