[AccessD] Check box on a form

Arthur Fuller fuller.artful at gmail.com
Thu Feb 2 09:04:03 CST 2012


If it's a SELECT query it won't update the field. You'll need an UPDATE
query.

On Thu, Feb 2, 2012 at 9:53 AM, Kaup, Chester <Chester_Kaup at kindermorgan.com
> wrote:

> I put the following code in the After Insert event of the form. When
> entering data on the form after the last field to enter data is completed
> the query runs and the results come up on the screen. I then close the
> query but the result is not saved to the table. Filed is a yes/no field.
> Should it be a select or an update query? Thanks for the assistance.
>
> Private Sub Form_AfterInsert()
>    DoCmd.OpenQuery ("qry Previously Test Flag")
> End Sub
>
> --
>
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr


More information about the AccessD mailing list