?
Solved

Go to New record on subform Disabled control

Posted on 2014-09-14
11
Medium Priority
?
408 Views
Last Modified: 2014-09-15
I have a main form "Standards" with a subform (Continuous Form), "NatureofNonConformance" on a tabbed page on the main form. If Non Conformance is selected on the Main form the user is directed to the Subform. Here they enter the details of the non conformance.

I have put the follow code into the On Current event of the subform to prevent users deleting or editing previously entered details ( I cannot disable edits etc on the subform as there are other controls that need to be editable , "ActionCompleteBy")

If Not IsNull(Me!NatureofNC) Then
Me!NatureofNC.Enabled = False
Else
Me!NatureofNC.Enabled = True
End If

I also have a command button on the main form, to enable viewing and editing of enabled controls, which sets focus on the subform.

using:
 Me!NatureofNonConformance.SetFocus


I would like to go to a new record on the subform to enable additional entries, however, when I use
 Me!NatureofNonConformance.SetFocus
DoCmd.GoToRecord , , acNewRec

it takes me to a new record on the main form.
Ideally I would like the command button to take me to the subform on a new record, setting focus on the "NatureofNC" control.

Where am I going wrong?
0
Comment
Question by:SparkyP
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 85
ID: 40321624
Try setting focus to a Control on that subform:

Me!NatureofNonConformance.SetFocus
Me!NatureofNonConformance.Form.SomeControl.SetFocus
0
 

Author Comment

by:SparkyP
ID: 40321634
Thanks Scott

That works fine, but takes me to the first record in the subform, rather than a new one. Where would I put the:
DoCmd.GoToRecord , , acNewRec
0
 
LVL 85
ID: 40321635
Not that this has anything to do with your trouble, but you can do away with those If blocks if you're prefer:

Me!NatureofNC.Enabled = Not IsNull(Me!NatureofNC)
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 85
ID: 40321637
but takes me to the first record in the subform, rather than a new one
After the second line ... sorry, thought that was understood :)
0
 

Author Comment

by:SparkyP
ID: 40321642
That's what I have being doing, but that takes me to anew record on the main form

 Me!NatureofNonConformance.SetFocus
 Me!NatureofNonConformance.Form.SomeControl.SetFocus
 DoCmd.GoToRecord , , acNewRec
0
 
LVL 85
ID: 40321652
Try setting focus to the FORM object in the first line:

 Me!NatureofNonConformance.FORM.SetFocus
 Me!NatureofNonConformance.Form.SomeControl.SetFocus
 DoCmd.GoToRecord , , acNewRec
0
 

Author Comment

by:SparkyP
ID: 40321660
Scott I get

There is an invalid method in expression when I add Form
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40323158
What's the name of your Subform CONTROL? You must be certain about that ...Subform
0
 

Author Comment

by:SparkyP
ID: 40323213
Scott

Thank you for all your help. Your image made me think about the Tabbed Page. I needed to focus on the Page before moving to the subform and control.

Me!Page243.setfocus
Me!NatureofNonConformance.FORM.SetFocus
 Me!NatureofNonConformance.Form.NatureOfNC.SetFocus
 DoCmd.GoToRecord , , acNewRec

Thanks again for your patience.

Mark
0
 

Author Closing Comment

by:SparkyP
ID: 40323279
Scott

 Thank you for all your help. Your image made me think about the Tabbed Page. I needed to focus on the Page before moving to the subform and control.

 Me!Page243.setfocus
 Me!NatureofNonConformance.FORM.SetFocus
  Me!NatureofNonConformance.Form.NatureOfNC.SetFocus
  DoCmd.GoToRecord , , acNewRec

 Thanks again for your patience.

 Mark
0
 
LVL 85
ID: 40323322
So for others who might find this:

You must focus on the Tab page first, THEN the Subform CONTROL, and finally a control on the subform.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question