Darren D
darren at activebilling.com.au
Wed Jul 9 23:11:46 CDT 2008
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