[AccessD] Check box on a form

That is what I was thinking. Made the change and it works great. Thanks.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Thursday, February 02, 2012 9:04 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Check box on a form

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
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com