Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    Hi,

    I have a database that opens a form in data entry mode or Edit mode from a switchboard, see screen shot below. My question is how do I hide the Find Account Combo box when in Add Mode?

    Any advice would be most welcome.

    [attachment=85768ataEntryForm.jpg]
    Attached Images Attached Images
    Maria
    Simmo7
    Victoria, Australia

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You can use the On Load event of the form. Let's say that the combo box is named cboFindAccount:

    Code:
    Private Sub Form_Load()
      Me.[cboFindAccount].Visible = Not Me.DataEntry
    End Sub
    (The square brackets around the control name are only necessary if the name contains spaces or punctuation).

  3. #3
    Star Lounger
    Join Date
    Feb 2009
    Location
    Kings Park, Victoria, Australia
    Posts
    90
    Thanks
    15
    Thanked 5 Times in 5 Posts
    Thanks Hans - worked a treat. I knew it could be done but didn't know the code to use.
    Maria
    Simmo7
    Victoria, Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •