Solved

Go to New record on subform Disabled control

Posted on 2014-09-14
11
406 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

635 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