How to show data from a diff table

[NeoPa]

@Nico

Do you appreciate that the resultant string from your code will have spaces around the value and between the single-quotes (')?
Also, the question doesn't make it very clear unfortunately, but from a quick perusal I assume the code being played with is to set a field within a query. If that is true then it is essentially SQL, so wouldn't recognise the word "Me". I may be misinterpreting this, but I guess if it starts with an "=" it must be somewhere outside of VBA. It's very unlike you to make such errors so I'm half expecting I've missed an important point, but I'd be interested to hear what it is if so - even if I do end up embarrassed :-D

[nico5038]

Hi NeoPa,

The spaces were caused by my Dutch keyboard settings (they require an additional space to be pressed to show just a ' or ", else I get a accented character like: é

AS the questioner stated: "I tried this by creating a text box and wrote the code starting with a "="."
I assumed he tried this from an unbound form field.
My assumption about the [Me] is however wrong, I did test it now and found out that Access doesn't recognize the [Me] object in such fields, as it does in the VBA.

So my previous comment should be ignored :-)

Nic;o)

[NeoPa]

Hi Nico :-)

It sucks that the keyboard settings cause that :-(, at least that's clear now though. Well done for clarifying.