Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to Hide/Unhide Field on a Base Form or SubForm

I am in need of this control. Since LOBase doesn't have TAB like Access does; So I am thinking have Push Buttons on the top underneath set of fields from different subforms. Issue is too many fields to display at the same time; so I would like to hide the once aren't needed at the present stage of the user flow. Here is an example:

  • I have buttons for ADDRESS, CONTACT,NOTEs etc.
  • So when pressed Address Button only subForm_Address will be visible on the MainForm CONTACT subForm and NOTEs SubForm will be non-Visible.
  • After lot of Google; I found following set of code which will control the background color of a field; now I need to access the property of Visible to set it to be True/False

    Dim oForm As Object, oTempAdd1 As Object

    oForm=oEvent.Source.Model.Parent REM CODE BOUND TO FORM BUTTON

    oTempAdd1= oForm.getByName("txtAdd1")

    tempColor = oTempAdd1.Background

    oTempAdd1.BackgroundColor = "255"

Thanks in advance for your TEACHING!!!

`

How to Hide/Unhide Field Field(s) on a Base Form or a SubForm

I am in need of this control. Since LOBase doesn't have TAB like Access does; So I am thinking have Push Buttons on the top underneath set of fields from different subforms. Issue is too many fields to display at the same time; so I would like to hide the once aren't needed at the present stage of the user flow. Here is an example:

  • I have buttons for ADDRESS, CONTACT,NOTEs etc.
  • So when pressed Address Button Address_Button, only subForm_Address will be visible on the MainForm MainForm. CONTACT subForm and NOTEs SubForm will be non-Visible.
  • After lot of Google; I found following set of code which will control the background color of a field; now I need to access the property of Visible to set it to be True/False

    Dim oForm As Object, oTempAdd1 As Object

    oForm=oEvent.Source.Model.Parent REM CODE BOUND TO FORM BUTTON

    oTempAdd1= oForm.getByName("txtAdd1")

    tempColor = oTempAdd1.Background

    oTempAdd1.BackgroundColor = "255"

Thanks in advance for your TEACHING!!!

`