Charlotte Foust
cfoust at infostatsystems.com
Tue Dec 19 15:30:52 CST 2006
Why bother to lock fields on an unbound form? Does the Edit button do something special? If you must, just cycle through the controls and for that particular type of control, set its Locked property to true. Without using a separate class, you can still build collections of controls types and step through the collections setting the property to true or false. A quick and dirty alternative would be to put a transparent control over the form and use code to make it "visible" when you want the data controls unavailable. Not knowing what exactly you intend to demonstrate, I can't make really useful suggestions. I do have a few demos on Roger's Access site that use unbound forms, but I don't think any of them lock the controls. http://www.rogersaccesslibrary.com/OtherLibraries.asp#Foust,Charlotte Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Martin Reid Sent: Tuesday, December 19, 2006 10:51 AM 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