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

Change property of command button by navigating access form

P: 19
I have an access form having a command button which will perform a certain action onclick for the current record.
I need to disable the button function by navigating the records before the current one from the form or in other words, to have the button property (enabled) = false all the time except when the current record is new only.

this makes me thinking on how to inform access vba to navigate and if the current record is a new one, then to enable the button to perform its function, or if it is one preivouse record then to nake the button property (enabled) = false.

Can this be performed and works?
Sep 7 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 5,397
In the oncurrent event of the form
me.newrecord will return state as bolean

Place the code there to check and set the control state as needed.

Sep 7 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.