Set Focus to Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I set to Focus to a particular field on a Subform when I am on the
Parent Form.
I want to goto a NEW record on Subform: Order Details Subform
and start on Field: ProductID
Parent Form Name: Orders
 
Yup, it is your reference to the subform. Here is the syntax

forms![yourParentFormname]![YourSubFormname].form![Fieldname].setfocus

Don't omit the '.form' in the syntax. subforms of suborms etc work in the
same way

Roger Carlson said:
On my website, (www.rogersaccesslibrary.com) is a small sample database
called "SubformReference.mdb" which illustrates this, plus a number of other
issues with referencing subforms and subsubforms.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
Click to expand...
 
Back
Top