Originally Posted by
ranman256
Query = datasheet Form
they are the same thing.
Not true. A Query is displayed in a datasheet format, but it is not a Form, and does not have Form events such as Before Update, After Update, etc., which the OP is using!
When opening a Form in Datasheet View, using DoCmd.OpenForm, you have to do so explicitly, using the acFormView parameter:
DoCmd.OpenForm "frmMain", acFormDS , , "[ReleasedAtBank]=false"
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007