Spaces in field names!

[elziko]

I'm updating a field which has a sapce in its name. Great:

arecorset![a field]=astring

However, "a field" is not decided on at design-time but at run-time using a variable. How would I use a variable instead of "a field" so that it works even when the variable contains a space? Obviously "[a field]" is not a string to I cant concatenate:

"[" & thevariable & "]"

I've already tried that. Is it possible??

Thanks

elziko

 

[Antzz]

Are you using SQL Server or Access?

 

[elziko]

What? I dont get it? Neither! I'm doing it from VB. Is that what you are asking??