what is the diference between Form_MySubform and Forms!MySubform

[smercer]

Hi all

1)I am wondering what is the difference between the

Form_MySubform

and

Forms!MySubform

2) I have heard that Form_ variety causes corruption. In what way? the way data is stored or the form itself?

3) When I try to change the record source in a subform from the main form or elsewhere I can't use the Forms!MySubform and need to resort to using Form_MySubform.RecordSource = "tbl_Table". is there a way to do this with out the corruption?

Thanks in advance for any help offered!!

 

[WayneRyan]

S,

The underscore is just another character.

Form!MySubform is just the name of something. It may or may not have
anything to do with a form(s).

If you use spaces in the names of your controls/variables, Access will
sometimes "take the liberty" of using the underscore character.

You name it "Total Score", you may refer to it as [Total Score], and at
times Access will insist on calling it Total_Score.

Generally, eliminate the confusion and call it TotalScore.

Anyway, I think that Mile put a very good presentation in the FAQ section
on how to reference objects on your forms/subforms, etc.

Wayne

 

[WayneRyan]

S,

This article:

http://www.access-programmers.co.uk/forums/showthread.php?t=66115

Wayne

 

[smercer]

Thanks wyane

That fixed most of my problems.