disable a97 controls upon reaching "new record"

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • MLH

    disable a97 controls upon reaching "new record"

    I have an A97 form with Allow Edits, Allow Deletions and
    Allow Additions properties set. Scrolling through records
    will eventually take me to the end of the records and one
    more PgDn will take me to a new record. I also have a
    cmd button on the form to take me instantly to a new
    record.

    There are 2 controls on the form I would like disabled
    whenever I'm at a new record. I want them enabled at
    all other times. Which event property would be most
    suitable for this and what conditions do I check for?
  • Arno R

    #2
    Re: disable a97 controls upon reaching "new record"


    "MLH" <CRCI@NorthStat e.netschreef in bericht news:5acit31tke jlid6i2opc9m9j3 lb2bnorl8@4ax.c om...
    >I have an A97 form with Allow Edits, Allow Deletions and
    Allow Additions properties set. Scrolling through records
    will eventually take me to the end of the records and one
    more PgDn will take me to a new record. I also have a
    cmd button on the form to take me instantly to a new
    record.

    There are 2 controls on the form I would like disabled
    whenever I'm at a new record. I want them enabled at
    all other times. Which event property would be most
    suitable for this and what conditions do I check for?
    Use the Form_Current event (IMO you *should* know this...)
    If Me.NewRecord .....

    Arno R

    Comment

    • Salad

      #3
      Re: disable a97 controls upon reaching &quot;new record&quot;

      MLH wrote:
      I have an A97 form with Allow Edits, Allow Deletions and
      Allow Additions properties set. Scrolling through records
      will eventually take me to the end of the records and one
      more PgDn will take me to a new record. I also have a
      cmd button on the form to take me instantly to a new
      record.
      >
      There are 2 controls on the form I would like disabled
      whenever I'm at a new record. I want them enabled at
      all other times. Which event property would be most
      suitable for this and what conditions do I check for?
      In the OnCurrent field you could do something like
      Me.TextField.En abled = (Not Me.NewRecord)

      Sealed

      Comment

      Working...