[AccessD] get focus back to subform - URGENT

Thanks Darren

----- Original Message ----- 
From: "Darren D" <darren at activebilling.com.au>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Thursday, July 10, 2008 2:11 PM
Subject: Re: [AccessD] get focus back to subform - URGENT


> Hi Kath
>
> Be explicit then - Something like
>
> ...Some Code
> me.parent.requery
> 'Then
> Forms!frmSomeMainForm.form.somesubform.somesubformcontrol.setfocus
> ...some code
>
> Re your earlier post about moving between controls
> I assume you want the user to just tab away happily and move between the
> subform and the main form without really knowing or seeing any difference
>
> I do this explicitly too - I determine the 'last' control on the main form
> then on the 'lostfocus' of that field I have something like
> Forms!frmSomeMainForm.form.somesubform.somesubformcontrol.setfocus
> And the reverse on the last control on the sub form
>
> There are probably better ways to do this but this is simple and it works
> for end user navigation well enough
>
> See ya
>
> DD
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
> Sent: Friday, 11 July 2008 1:52 PM
> To: Access D Normal List
> Subject: [AccessD] get focus back to subform - URGENT
>
> Must be a bad day....
>
>>From a control on a subform, when I say
> me.parent.requery,
>
> I then cannot get the focus back to my control on the subform using:
>
> me.controlname.setfocus.
>
> Any tips? This should be easy stuff but driving  me mad today.........
> tia
>
> Kath
> ______________________________________
> Kath Pelletti
> -- 
> 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
>