Member name in form header

[dniezby]

There was a form i saw in a sample database that would display a members name as i typed it into a form. I opened it up and put the code in my program but it doesnt work.



How do i do that? i want the member name and id to be displayed on my form as a user enters it.

In the sample it appeared to be a label field and the caption had something with Nz in it????

[June7]

Where did you put the code? Is it a function? If you have the sample database, follow the design used and apply to your db. What is in the textbox event properties?

Here is tutorial for creating the 'find as you type' textbox http://allenbrowne.com/AppFindAsUType.html

Why not use a combobox?

[dniezby]

Okay, solved this issue too.

It's a decorative feature on my form so the name displays on the top of the form. Just makes for easier navigation of the form and aesthetics.

Created a Textbox
DATA tab =

• ENABLED: YES
• LOCKED:YES
• CONTROL SOURCE: Nz([fullname],"Undefined")

That's it!

Now when someone is working with the form and they type in Last and first name, it displays on the top of my form. You must note, that I already have a calculated field to create the fullname. If you want to add more field results to this you'd need to put them in parentheses.

For example, say I want the member ID to show up too.

Nz( ( [fullname]&","&[Member_id]),"Undefined")

By enclosing those in parentheses, it processes those fields first before moving on to the "Undefined"