Search results

DB attached. Recap. frmMaster is the main form, with 2 subforms [frmSection_sub] and [frmGroup_sub]. I used the Tag control to identify all controls as A, for those to be available All the time, and then T2, T3, and T4 for the respective controls to be manipulated. [frmSection_sub] has the...

Ridder, Sorry, been offline for a little bit. I was wondering if I could send you my db so you could take a look at how I handled the use of the tag function.

I just reworked it from a clean db and still not working. Is there a way to send it to you in a private thread?

ridders, Thanks so much for the guidance.

Ok. I am sure that I put the identifiers in the right spot. Like I mentioned, I probably butchered it up so bad that I have the form running in circles. I will start with a fresh, clean form.

Yes, they are tagged A for all controls I want visible, and T2 for those that I want to hide. I have only tagged the T2 group for now. I still have the T3 and T4 group to re-tag. Currently they are set for A. I am going to pull a clean db and start over. I have made so many changes that I...

So I put a control on the actual form, outside the 2 subforms, and it works perfectly with my buttons. Any of the controls inside subforms 1 & 2 does not.

Is the SetControl function something new? Looking at your db, I do not see the SetControl function. Here is what I used from your db and I already have it on Form_Load ShowControls True, "A" ShowControls False,"T2", "T3"

ridders, I have tagged all my controls "A" for always visible, and then tagged the ones I want to hide as "T2". I have copied both of your modules over to my db, but it still does not hide the controls. It has however stopped hiding random other controls. So that issue is resolved. Do I also...

You hit the nail right on the head. Others will be using this db and I do take a lot of pride in my work. I love that saying about knowing where the machine's power cord is plugged in! I will have to drop that one sometime and see what response I get! Thanks again for the guidance.

The_Doc_Man, You gave me good information, and things to take into consideration, especially making sure the controls are adapted to the expected conditions for new and existing records. I tend to be a perfectionist and want my db's to run correctly all of the time. Errors are frustrating...

Excellent! Now it is making more sense, and I like the idea of drawing control focus on a command button. I will hopefully get time to work on this tomorrow. Thanks!!

ridders, Finally had a little time to get back to this db. I marked by tags for the controls, T2 (group 2 controls) for now. Eventually I will tag the other controls T3 & T4 respectively based on when they are needed by the user. I used the modules from your example db, and the code on the...

ridders, Good point. I will post the method and code I used once fully completed. That will probably be mid-week due to other work "fires" that taking priority today.

ridders, arnelgp, & The_Doc_Man: Thank you each for your replies and examples. I now have it figured out using your guidance!! On to the next quest! Smokeeater

I will look at the information on use of the tag property. I may not have done a good job of explaining how the subform is being used. There are 4 different groups of controls on the form. Each group holds 15 controls. The first 10 are always visible. Depending on the activity, the user can...

pbaldy, thank you for the reply. All of the code will be used in the same form, but for different events, that is why it is needed several times.

Ridders, thank you for the reply. I would prefer to not tie these back to a tag on a control. The end user will unhide a large number of fields all at once, based on need. If not needed, them all of them in the module will stay hidden. If they are needed, I see them using a button to unhide...

I have code tied to a command button on a subform, however, it is both lengthy and needs to be used in multiple locations (OnOpen, On Current, etc.). I would like to use a module instead, however, the code "hangs up" on each of the control names. I have tried to use the ME! and Me. identifier...

arnelgp, ridders, & Minty, Thank you each for your replies. I sort of knew what I thought would be the best course of action, and that is to restructure the names, so that is what I will do. Like you mentioned ridders, each version is less tolerable to mistakes or poor coding used in previous...