i have a form with Record Source is a Account Table with a field AccName.
i use a textbox (named AccName) with Control Source set to AccName field.
when i set focus to this textbox, i get compile error : invalid qualifier
Code:Me.AccName.SetFocus
i have a form with Record Source is a Account Table with a field AccName.
i use a textbox (named AccName) with Control Source set to AccName field.
when i set focus to this textbox, i get compile error : invalid qualifier
Code:Me.AccName.SetFocus
I always rename controls so Access doesn't get confused - I would name the text box "tbAccName" (tb = textbox)
Do a "Compact and Repair".
You could delete the text box, do a "Compact and Repair", then re-create the text box bound to "AccName" (rename the control as above).
should adopt a naming convention and while at it, avoid reserved words, spaces and special characters (except possibly underscore, which I don't use)
I find this one a bit too expansive (e.g. I only use qry for query preface and let the icons in the nav pane tell me which type it is if I forget)
- http://access.mvps.org/access/general/gen0012.htm
https://www.access-programmers.co.uk...d.php?t=225837
What not to use in names
- http://allenbrowne.com/AppIssueBadWord.html
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.