quote:Originally posted by sal
Never allow a user to change/edit/add data with a form in datasheet view or continuous form
I rarely ever use continuous forms because they present lots of formatting problems (they usually behave all or nothing instead of per record). However, there are times when I let people edit things in datasheet view. In fact, the datasheet view is much more convenient and user-friendly in some cases. For example, if someone is entering stack parameters for an output stack and they're entering stack no., diameter, height, flowrate, etc. To see them lined up in datasheet view is more intuitive than one at a time on a form.
They way I avoid accidental saves is that the form and subform (datasheet view) are read-only until an EDIT button is pressed. At that point a label on the upper right of the form header changes from a green "VIEW" to a red "EDIT". When the user moves to the next record, everything reverts to read-only again.
Hey! I hit 200 posts! I'm a member now! I'd like to thank the Academy...
Michigan Dept. of Environmental Quality, Air Quality Division