Joe Hecht
jmhla at earthlink.net
Sat Apr 24 19:54:14 CDT 2004
It is the cbo.requery that I needed. Thanks JOE HECHT LOS ANGELES CA -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Tuesday, April 20, 2004 3:19 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] cbo after adding data question Hi Joe If you have one or two places on the form which can add/alter records and therefore require the cbo to be requeried then just add: me!cboWhatever.Requery at the end of those routines. Alternatively, and as long as it doesn't cause too much of an overhead, you can place: me.ActiveControl.Requery in the OnGotFocus of the combo itself. You may do more requeries than are strictly necessary this way, but it pretty much ensures that the combo sees everything it should. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: Access Developers discussion and problem solving <accessd at databaseadvisors.com> To: AccessD <AccessD at databaseadvisors.com> Subject: [AccessD] cbo after adding data question Date: 20/04/04 06:53 > > I have a combo box that pulls up matching records on a form. The data source > is a SQL statement not a query. > > > > After the record is entered where and how should I write the requry > statement to add the record to the combo box? > > > > JOE HECHT > > LOS ANGELES CA > > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > > > ________________________________________________ Message sent using UebiMiau 2.7.2 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com