Dim of Objects -- Form then Set equal to form name ???

[TenOc]

I am new to VBA but have used Access with Macros for a number of years. I have a form call it "frmAllBenf" with a sub-form call it "sfmMain". The old book I am using to teach myself VBA says to Dim as an object and then Set the object equal to the form as below.

Dim myBenf as form
Dim myMain as form


Set myBenf = Forms ("frmAllBenf")
Set myMain = Forms ("sfmMain")

The Access 2019 VBA give me the option to Dim as below. My Question is what is the difference in the two types of Dim statements. Is there an advantage in one over the other?

Dim myBenf As Form_frmAllBenf

Dim myMain As Form_sfmMain

Do I is still need a Set statement as is myBenf now = to frmAllBenf? Is there a good link to explain what the second Dim method does?

[ranman256]

No,they are all synonyms.
but why the need to assign? If the user is in the form, why reference the form?
users need the objects on the form....me.combo, or me.txtbox.

[TenOc]

No,they are all synonyms.

Are you by saying "no" I do not need to Set? Or are you saying the Dim statement are synonyms?

but why the need to assign? If the user is in the form, why reference the form?

The user may be in a different form when the action takes place.

users need the objects on the form....me.combo, or me.txtbox.

See my reply in the Quote

[ranman256]

A user normally need only work in 1 form. Everything should be in it.
and less the need to make Dim statements to reference other forms.

[TenOc]

A user normally need only work in 1 form. Everything should be in it.
and less the need to make Dim statements to reference other forms.

I am trying to write a public function or sub that will help me accomplish the problem in my posting at https://www.accessforums.net/showthread.php?t=76267. I have 4 forms each with 3 buttons. I do not want to copy and past 12 code procedures with only small differences in the code, but it may be faster than trying to learn something new.

[Micron]

Why start a new thread when you had 2 replies there but haven't responded?

[TenOc]

Why start a new thread when you had 2 replies there but haven't responded?

It was a complete differ issue. The first posting was about what METHOD to use. The second posting was about IMPLEMENTATION of the method. Sorry if I should have combined the two.

[Micron]

No apologies necessary, I'd say, but it's weird because it's really the same issue regardless of whether or not it's about the method or implementation of the method.

What seems suspect is that you have multiple forms and you want to kick off the same procedure for all 3. Not unusual to do that for a set of controls on a form, but I think it is for multiple forms. Regardless, to answer your question, whenever you create a variable of type object you need to SET it to be some object, and when you're done with it, you should SET it to Nothing, otherwise you don't reclaim machine memory, because objects are stored there.

Whatever it is you're doing, you might be making it more complicated than what is necessary.