[AccessD] get focus back to subform - URGENT

Charlotte Foust cfoust at infostatsystems.com
Mon Jul 14 10:26:54 CDT 2008


Kath,

Me.Parent.Requery is the problem, and I don't understand why you want to
use it.  When you requery the parent, you requery everything, so the
"next" control is meaningless anyhow.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kath Pelletti
Sent: Sunday, July 13, 2008 4:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [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
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list