[AccessD] Requery Control and move to another - Solved

Required only three lines...
Once the ComboBox (column 1 of the ListBox) is changed, I refreshed
Subform1,
requeried the ListBox, then set focus to destination field.

Me.Refresh 'the ComboBox is column(1) of the ListBox
Forms("frmMain")("ListBox").Requery
subform2.setfocus  'destination field is first field in subform

Thanks,
Jim

-----Original Message-----
From: Mitsules, Mark [mailto:Mark.Mitsules at ngc.com]
Sent: Friday, July 25, 2003 12:57 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [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 >> 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com