Still a field with #Name? though every control has been renamed

L

Lars Gustavsson

Hi!

I still receive a form combo field with #Name? I have renamed every
control to be using the naming convention for objects and textboxes,
with txt..., combos with cbo... etc. Before, all controls have the
same name as the linked table fields, which I know is not the
apropriate way to name controls, but this is an inheritated app.

Now I'm run out of ideas. Hope anyone out there with new fresh ideas
on what to search for.

TIA
 
T

tina

check the RecordSource of the combo box control. is it a valid name of a
field in the underlying table/query?

hth
 
T

Tony D'Ambra

Are you requerying the RecordSource in code? If so, you need to also reset
the the Value to "" or vbNullString.

Tony D'Ambra
Web Site: aadconsulting.com
Web Blog: accessextra.net
 
T

Tom Wickerath

Hi Lars,

Check out the following KB article:

Troubleshooting Tips for Error Values
http://support.microsoft.com/?id=209132

The section on #Name includes checking for valid recordsources, as Tina suggests. It also shows
other causes.

Tom
______________________________________


check the RecordSource of the combo box control. is it a valid name of a
field in the underlying table/query?

hth

______________________________________
 
Top