Set focus to Tab control when subform has records 1

[Utracman]

A97

How would I do this?

One of my tab controls [Critical Issues] has a subform that displays Issues that need to be resolved and when they get resolved they will not show up in the subform. What I want to do is if there are records present in the subform I want to set focus to the Tab control [Critical Issues] when the main form is opened. This way the user is informed they have issues to resolve right away.


Thoughts?

Thansk for the help To learn fron those who have mastered the art..... Saves many headaches!

 

[JoeMiller]

Run a DCount on the query feeding the subform in the OnOpen event of the form, if there are any records use the SetFocus method to higlight the tab.

HTH Joe Miller
joe.miller@flotech.net

 

[Utracman]

Joe

I'm close but it always sets focus to the tab even if there are no records.

Code

If DCount([IssueID], "qryCriticalSub", [Sales ID] = Forms!frmBranchMain![txtSales ID]) > 1 Then
Forms!frmBranchMain!tabCritIssues.SetFocus

What am I missing?

Thanks

Dave To learn fron those who have mastered the art..... Saves many headaches!

 

[JoeMiller]

You DCount statement has it's criteria set wrong for one thing. Try this:

If DCount("[IssueID]", "qryCriticalSub", "[Sales ID] = [Forms]![frmBranchMain]![txtSales ID]&quot > 1 Then
tabCritIssues.SetFocus
End If Joe Miller
joe.miller@flotech.net

 

[JoeMiller]

Another thing, you may want to change your code so that it fires for greater than 0 so that it fires when there are any critical issues. Your current code will only fire if there are 2 issues. Joe Miller
joe.miller@flotech.net

 

[Utracman]

Perfect!

Thanks for the help

Dave To learn fron those who have mastered the art..... Saves many headaches!