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

[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

 

[tina]

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

hth

 

[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

 

[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

______________________________________