Connecting Tech Pros Worldwide Help | Site Map

disable a97 controls upon reaching "new record"

MLH
Guest
 
Posts: n/a
#1: Mar 13 '08
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
Guest
 
Posts: n/a
#2: Mar 13 '08

re: disable a97 controls upon reaching "new record"



"MLH" <CRCI@NorthState.netschreef in bericht news:5acit31tkejlid6i2opc9m9j3lb2bnorl8@4ax.com...
Quote:
>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
Salad
Guest
 
Posts: n/a
#3: Mar 13 '08

re: disable a97 controls upon reaching "new record"


MLH wrote:
Quote:
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.Enabled = (Not Me.NewRecord)

Sealed
http://www.youtube.com/watch?v=QrYM2Gt9sMw
Closed Thread