Record Source = to name of Form

[beckwiga]

Hello all,

What is the best way to programmatically set my Record Source(on the Data tab of my form) to the Name of the Form itself?(I will also have a table with the same name as the Form which is what I will really be using as my Record Source) Can I just code this in the Data tab, or do I need to do this in VBA somehow in an OnOpen event, setting my .RecordSource to something. Any ideas? This is Access 2003.

Any input would be appreciated.

 

[PHV]

In the Open event procedure:
Me.RecordSource = Me.Name

But why doing it programmatically ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

beckwiga . . . . .

The RecordSource of a form can be:
[ol][blue][li]TableName[/li]
[li]QueryName[/li]
[li]SQL (not in your case)[/li][/blue][/ol]
[purple]Unless you intend to name one of the above onjects your form name . . . . whats the point!?[/purple]

See Ya! . . . . . .

 

[MichaelRed]

beyond the obvious, this is a POOR practice. Having different objects with the same name confuses both people and (at least occassionally) the programming. Look up something called Reddick or most any naming convention you can find in most any text re programming in general.





MichaelRed

 

[beckwiga]

Thanks for the feedback guys.

 

[missinglinq]

MichaelRed is right! You should NEVER name multiple objects exactly the same. When I do a really big project, I'll use a common root name and tag on the object type. Thus, for a portion of the app dealing with visit reports, I'll use VisitReportsForm, VisitReportsQuery and VisitReportsReport. This way you (and anyone down the road, following in your footsteps) can readily tell what goes with what, without confusing Access!

The Missinglinq

There's ALWAYS more than one way to skin a cat!