Help with #Name? error

[KLahvic]

I have a table "tblvndmstr" with a first name, last name and middle initial fields. I have a form "frmvndrentry" where in the header I want a textbox to combine the first, mi and last name of the current entry. I used the following expression to do this: =[FirstName] & " " & [MI] & " " & [LastName] When I start with a fresh text box it works, until I close the database. When I reopen I get the #Name? in the textbox that just moments before populated the information as requested.

Any ideas on what I am missing here?



Thanks in Advance
Ken

[llkhoutx]

The instant error fires when your concatenation formula uses an invalid name.

If any of the fields is null, you'll get an erroneous result., but that's another issue.