Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / January 2005

Tip: Looking for answers? Try searching our database.

lock down the records on the form when a flag is marked "yes"

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jessica - 14 Jan 2005 18:47 GMT
I want to lock down some of the records on the form where the flag column for
that record is marked "yes".

for example I want to nobody can change the "Purchase Order table/query" via
"Purchase Order form" if one control/column named "Status" of the "Purchase
Order" form/table has been marked as "Finished".
They can view the Purchase Order form and navigate the records but can not
update the Purchase Order information as soon as the "Status" is "Finished".

I think I can not using "On Open" event procedure of the form because
"OnOpen" only trigged when the form is opened, but I need navigate the record
and if the status is "Finished" on that purchase order record then lock down
all the controls on the form by using "setvalue" for the enable property, am
I right?

So on the form which event I should use? any solution for that? I would
appreciate your answer or comments!
Rick B - 14 Jan 2005 18:57 GMT
Jessica:

This same type of question was just answered a day or two ago.  This is a
very common request.

Please do a search and look at previous posts.  There is no need to retype
an answer if you can simply reread the previous posts.

The key is to use the "on current" event to do your checking as you move to
different record.

Rick B

> I want to lock down some of the records on the form where the flag column for
> that record is marked "yes".
[quoted text clipped - 13 lines]
> So on the form which event I should use? any solution for that? I would
> appreciate your answer or comments!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.