Last and first name

[daniel]

I am trying to show both names in the lastname field like:
ControlSource: =" " & [LastName] & ", " & [FirstName]

what is it that i'm writing wrong ?

thanks

 

[Allen Browne]

That should work, assuming the LastName and FirstName are fields in the
form's RecordSource.

Try renaming this text box. Access gets confused if it has the same name as
a field, but is bound to something else.

 

[daniel]

ahh, I made a new text box and it worked. even though I named the field
txtLastName it
didn't like it. it did with the new one, Text88.
I say, should have thought about that myself.
Thank you, Allen.

That should work, assuming the LastName and FirstName are fields in the
form's RecordSource.

Try renaming this text box. Access gets confused if it has the same name
as a field, but is bound to something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am trying to show both names in the lastname field like:
ControlSource: =" " & [LastName] & ", " & [FirstName]

what is it that i'm writing wrong ?

thanks

 

[Delta23]

I am trying to show both names in the lastname field like:
ControlSource: =" " & [LastName] & ", " & [FirstName]

what is it that i'm writing wrong ?

thanks

I just did the same thing, I use this.... FullName: [LastName]&",
"&[FirstName]
and it worked fine

 

[daniel]

nad this also worked:
=[cboAccount].column(1) & ", " & [cboAccount].column(2)

thanks for all the help

I am trying to show both names in the lastname field like:
ControlSource: =" " & [LastName] & ", " & [FirstName]

what is it that i'm writing wrong ?

thanks

I just did the same thing, I use this.... FullName: [LastName]&",
"&[FirstName]
and it worked fine