Hiding SubForm Issue

cstimart

Well-known Member
Joined
Feb 25, 2010
Messages
1,180
I'm in Access 2007 and have a form, that when opened has a hidden subform.

When the user selects one of the 3 choices from a combo box, a query populates in a text box, the first item is automatically selected and the subform appears with the specific data showing from the selected query item.

The problem I am having is that when the user tabs out of the Combo box, the subform hides for some reason unknown to me.

Ideas? What am I missing?
 
Last edited:

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Too many possibilities imo.
Post the full code or even the form module code complete.
Maybe some other event ... can't really be sure.
 
Upvote 0
Too many possibilities imo.
Post the full code or even the form module code complete.
Maybe some other event ... can't really be sure.

Thanks for the info, and sorry for the delay...but I did find the problem. After much review, I was able to find another control that was happening afterwards that was changing the visibility.
 
Upvote 0

Forum statistics

Threads
1,221,813
Messages
6,162,117
Members
451,743
Latest member
matt3388

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top