We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Access 2010 trouble with tabs

OGSan
OGSan asked
on
Medium Priority
372 Views
Last Modified: 2012-05-11
Hi, Experts -
I have a simple stand-alone Access 2010 database (.mdb - using 2003 compatibility because we have a few stragglers who have not yet been upgraded). The users like tab controls. So, I created a form with sub-forms on each tab. So far, just two tabs each with their own sub-form.

On main form (first tab) - a combo box displays all employees.  Once an employee is selected,   Sub-form1 displays the fields from a query executed with code tied to the AfterUpdate event on the combo box.  All is fine there.

But the second tab's sub-form2 - which is supposed to display rows from a second query...also executed in the same code on the AfterUpdate event - displays nothing at all.  In the header portion of Sub-form2, I have the following Iif stmt, which is referencing fields in the query executed:  
     =IIf([ID]<>"",[EEName],"No Tuition Apps found for " & [EEName])

What am I doing wrong?
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Hamed NasrRetired IT Professional
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Thanks for the replies, Nicobo & hnasr.  I managed to figure out the problem(s) on my own.  Turned out my underlying query needed to be rewritten.  Splitting points between you but weighting more with Nicobo for his added thoughtfulness.  Thanks, again.
Jeff (aka OGSan)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.