Set Focus to Subform

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
 
G

Guest

G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Access 2007: Calculated field based on subform: 1
Set focus in a specific record within a subform 1
Searching for a record on a subform 1
Forms and sub forms 2
Focus to SubForm Control 10
How to set Subform Default Focus 1
setfocus on form control, not subform 4
Highlight rows in a subform datasheet view 0

Top