Name in form header

[jmanis]

I am trying to get a person's name to show up in the header of the form when their record is selected so the user knows which record they are looking at when going through the tabs.



I have searched all over and even tried the code on some of the Access templates but nothing seems to be working.

Does anyone have any ideas? If you are not sure what I am talking about the Faculty template has a good example and thats one of the templates I tried the code from.

Thanks!

[Access_Blaster]

Put something like this in a label, in the header.

="Contact: " & [FirstName] & " " & [LastName]

[jmanis]

No luck. When I put that as a label in the header it didnt do anything but show up as text.

[Access_Blaster]

Apologies: use a unbound textbox with some thing like this in the control source. ="Contact: " & [FirstName] & " " & [LastName]

[jmanis]

Worked. Thank you.

[maximus]

even better you can manipulate the form caption to display the name of the employee:

On the OnCurrent Event of the Form put this Code:

Me.Caption=Me.FirstName & " " & Me.LastName

[Access_Blaster]

You welcome glad it worked out for you.