I always have trouble using a specif field from one table in other objects. What's wrong?

[lbcarvalho]

I have the two tables above, CLIENTES (CLIENTS) and TRABALHOS (=JOBS) among others, but almost every time I want to use the field called MOEDA (=CURRENCY) I get error messages like #Name?

Maybe I'm doing something wrong, but I am not sure what.

Do I have to always create a query or do something else besides the regular association procedure to link the field MOEDA (=CURRENCY) to other objects like reports and forms?

Thanks in advance for any tip that may lead to the solution of this annoying problem!

lbcarvalho

[CarlettoFed]

Normally not, if you place an example file you could check what you say.

[lbcarvalho]

Let m try to make it clearer:

I built a subform that uses almost all of the fields in table TRABALHOS (=JOBS) and I want only one field (MOEDA (= CURRENCY)) from the other table, CLIENTES (=CLIENTS) and then I get the above mentioned error (#Name?).

[Gicu]

What is the subform's recordsource? Is it a query similar to the one you show in the first post?

Cheers,

[ssanfu]

Could be because "Currency" is a reserved word in Access (Jet) and shouldn't be used for object names.

Try changing it to something like "CurrencyType" - anything except Currency.

[davegri]

Ignore this post, see next.

[davegri]

Have you tried =Parent.[Moeda] for the control on the subform?

[lbcarvalho]

Thank you very much, ssanfu! Apparently you are right. I mean, the word MOEDA is really a reserved word in Brazilian Portuguese (I am in Brazil) as well as CURRENCY. I changed its name to VarMOEDA and it seems to have become easier now to find the variable.

I have been using the Field List to try to find the MOEDA (now VarMOEDA) field and it seems it got more simple now.

I'll post more info here as soon as I understand the process better.

Could be because "Currency" is a reserved word in Access (Jet) and shouldn't be used for object names.

Try changing it to something like "CurrencyType" - anything except Currency.

[lbcarvalho]

Thank you very much, davegri! Yes, I have tried =[CLIENTE]![MOEDA]. I guess that's what you are talking about, right?
Apparently it did not work, or, maybe, I have not made the correct adjustments. Not 100% sure.
So far, the use of a reserved word (MOEDA) seems to have caused all the issues.
I'll be testing my system and will let you guys know when I am more certain of what is going on.
Best regards!

Have you tried =Parent.[Moeda] for the control on the subform?

[davegri]

Yes, I have tried =[CLIENTE]![MOEDA]. I guess that's what you are talking about, right?

No, I meant exactly =Parent.[Moeda] as the control source for a textbox on the subform.

Edit:
In light of Post#8 the control source would be =Parent.[VarMoeda]