Using = [] gives an error

[Davidwazza]

Hi All

Righto, this is a fundamental problem that keeps repeating itself, and I dont know where I am going wrong!

Basically, I have a string, which in the record, shows up OK, say strCO. Yet, when I add =[strCO], it comes up with #Error. I think this has something to do with my record source: tblSquadrons. Like, it happens to me in somethings, yet when I put all the table into a query, and reference that, *I think* it turns out OK. Hence, I would like to place his rank in the same box, such as =[strRank] & " " & [strCO], but if I cant even get the basic thing first, yaaah!

My question is what makes it do that, and how I can avoid this issue, as opposed to placing all my tables into queries (which is useless anyway).

 

[dhookom]

David,
Your issue most likely is the name of the text box. Make sure the name of the text box is not the same as a name of a field. Access defaults all names of text boxes to the name of the field. If you then change the control source into an expression, the text box will show and error when run.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.