Drew Wutka
DWUTKA at marlow.com
Tue Dec 19 16:19:24 CST 2006
What's the purpose of locking the controls? In an unbound form, nothing is going to change in the tables unless you provide that route. Locking the controls is like putting a padlock on a wall. If you are using an unbound form for data entry/modification, you should be using a data class/collection in the background. You are in complete control of when the data gets changed. What's the real goal here Martin, why have an edit/save button instead of just a save? Personally, I use bound forms for most data entry things, if I'm using an Access front end. If I use unbound forms, it's because I want to control what's being done, so I can alert other things if necessary. With a data entry form, you could have a 'auto save' feature, where if it's one, changes are saved just like a bound form, if it's off, it prompts to save the data, or you could even hold all the changes in the classes/collection, and save in a batch process. Drew -----Original Message----- From: Martin Reid [mailto:mwp.reid at qub.ac.uk] Sent: Tuesday, December 19, 2006 3:42 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Unbound forms Drew At the moment I already use the controls tag property to cycle (as suggested by Charlotte) to lock all the controls when the form opens. The nav buttons then operate. What I wanted was a neat way to then click edit - at the moment I unlock the controls and disable all the other buttons. Catch the change and do an update if they actually changed anything or cancel. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: accessd-bounces at databaseadvisors.com on behalf of Drew Wutka Sent: Tue 19/12/2006 21:16 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Unbound forms More details please. When you say you have the fields locked, are we talking about table security, or do you have the controls locked? Drew -----Original Message----- From: Martin Reid [mailto:mwp.reid at qub.ac.uk] Sent: Tuesday, December 19, 2006 12:51 PM To: Access Developers discussion and problem solving Subject: [AccessD] Unbound forms For the book I am doing Unbound. The exampel I am doing has all fields locked. How do most of you deal with the click of an Edit button? Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com <http://www.databaseadvisors.com/>