[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