I have about 11 subforms on tabbed pages on a single form. I am trying to set them all with the exact same properties to eliminate the jumping--and need this type of coding for other things, too.
I wish to have a module which will control the size properties and the location of several "special textboxes."
I have variables for the actual subform names, strPageAfrm, strPageBfrm, etc. assigned as public constants since I will be duplicating this database many times with slightly different names. I want to change things once instead of 12 or multiples of 12 times.
In the On Current event I have the code <strCurrentSubform = strPageAfrm>, etc. (without the <>)
I found posts where I can reference the subform by
but I need to refer to the subform by also including the name of the parent form, I suppose. (Access tells me I have to do something different!)
Please write answers in general terms-- (like what I have above in < >). I think everyone understands that better than trying to use my actual terms.