David Emerson
newsgrps at dalyn.co.nz
Wed Feb 1 15:32:10 CST 2012
Hi Chester, The control source needs to be the field that you want the data stored in. To get the value of the query into the field you can use code (on Insert) . Regards David Emerson Dalyn Software Ltd Wellington, New Zealand At 2/02/2012, Kaup, Chester wrote: >I have a form that is used for data entry into a table. On the form >is a check box. The control source for the check box is a query >(=[qry Previously Test Flag]![Flag]). I have tried the query on its >own and it works fine. No data from the check box is getting saved >to the table. I am thinking that I need to do something to trigger >the query. Is that correct? > > >Chester Kaup > >Engineering Technician > >Kinder Morgan CO2 Company, LLP > >Office (432) 688-3797 > >FAX (432) 688-3799 > > > > > >No trees were killed in the sending of this message. However a large >number of electrons were terribly inconvenienced. > >-- >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com