[AccessD] Requery Control and move to another

Jim,

I'm not sure I can help yet, but do I have this right?

MainForm
|__TabCtl
|____ListBox.............(2. Requery this.)
|____SubForm1
|______ComboBox.....(1. AfterUpdate of this.)
|______SubForm2
|________DestField....(3. Then SetFocus to this.)



Mark


>  -----Original Message-----
> From: 	Jim Hewson [mailto:JHewson at karta.com
> <mailto:JHewson at karta.com> ] 
> Sent:	Friday, July 25, 2003 1:08 PM
> To:	'AccessD'
> Subject:	[AccessD] Requery Control and move to another
> 
> I'm having difficulty requerying a control.
> Access 2000
> 
> After updating a combo box, I want to refresh a list box, then go to
> another field on a subfrorm.
> 
> The combo box is on subform1, which is on a tab control.  The list box is
> on the same tab as subform1
> After updating subform1, I want to go to a field on subform2, which is a
> subform of subform1.
> 
> Update combo box located in subform1 on tab control
> refresh list box on tab control
> Go to field on subform2
> 
> How can I do this?
> 
> Thanks in advance.
> 
> Jim
>  << File: ATT846049.txt >>