By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,909 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

disable a97 controls upon reaching "new record"

P: n/a
MLH
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?
Mar 13 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"MLH" <CR**@NorthState.netschreef in bericht news:5a********************************@4ax.com...
>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
Mar 13 '08 #2

P: n/a
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.Enabled = (Not Me.NewRecord)

Sealed
http://www.youtube.com/watch?v=QrYM2Gt9sMw
Mar 13 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.