[AccessD] Tooo funny Help has a sense of the ironic

I got really ticked at the stupid 'no help' in A2K and I asked my question 
in a rather rude fashion (as in "How the F##K does dateadd work") because I 
forget from time to time -anyway....one of the subjects that came back was 
"How to speak to a computer"

Laughed out loud
_d
"Things are only free to the extent that you don't pay for them".-Don 
Elliker





>From: Jim Hewson <JHewson at karta.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem solving'" 
><accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Requery Control and move to another - Solved
>Date: Fri, 25 Jul 2003 13:46:48 -0500
>
>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
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail