Simple field concatenation in subform

[cpampas]

I am sure this shoud be something realy simple , but I cant see it:

in a subform i have a control bound to a field [country] another control bound to [city], it works fine but now i want to concatenate both in one control

=[country] & "-" & [city] ' the country appears blank

why is country in the control source diferent from =[country]

 

[theDBguy]

Try using the name of the control, rather than the name of the field it is bound to.

 

[Ranman256]

try:
=me.country & "-" & me.City

 

[cpampas]

When following theDBGuy sugestion, to refer to the control rather than the field, I noticed that one of my label names was already in use "country", therefor
the field name was not being recognized
Thanks for your help

 

[theDBguy]

When following theDBGuy sugestion, to refer to the control rather than the field, I noticed that one of my label names was already in use "country", therefor
the field name was not being recognized
Thanks for your help

Congratulations! Glad to hear you got it sorted out. Good luck with your project.