Originally Posted by
aytee111
In general practice, it is best if the name of the text box matches the name on the table/control source for bound fields.
If by this you mean that a textbox whose source is a table or query field (e.g. LName field) should have the same name as that field, I don't think I could disagree more.
Any information I've ever read about general naming conventions precludes this (e.g. naming the control txtLName). Besides, in my experience, once you've debugged a code problem where it turns out that Access didn't distinguish as intended between a control with the same name as its bound field, you probably would avoid that practice. At least that's how I roll.
If on the other hand you meant the textbox shouldn't be named Text12 (the typical default of a form built without using the form wizard), then I guess we'd agree.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.