Form Problems - mainly concantenation

[dalton]

I'm creating an access database for my father. I have some experience in access. I'm having trouble though. Right now, I have one table that includes things like: last name, first name, primary phone, secondary phone, address, city, state, zip, notes, category. I created a form from that. It worked fine. I deleted the first name label and text box. I changed the name of the last name label box to display "Name: ". It works fine if I go to the drop down menu in control source and pick one. However, I want to combine the first name and last name in the last name text box. At best I'm getting the text box to display "#Type!" I can't find what this means. I'm using the expression builder and it ends up being "=[Last_Name] & [First_Name]". This is what gives me the thing I mentioned above. Please help.



Also, I could use additional help. Basically, what I want is a form that pops up when the database is opened. It will have a list of all the contacts. When one is clicked on in the list box, I would like to have the primary and secondary numbers display in two text boxes at the bottom. I'd like a search bar at the top and maybe some sort options. I'd like to be able to double click on a name and have a second form come up with the complete information on the person. If you could tell me how to go about this, I'd really appreciate it. Do I do an on double click action for the list box or is it something like listbox.item on_double_click. These are the kinds of things I need to know. I know enough to know what I don't know, if you know what I mean. Thanks for all the help.

[kimmer]

Regarding the first question... by the way, I presume you are not using this form to enter people's names, right?
Check the name of the textbox... if it's named last_name, and the expression in the control source calls for last_name, well ya know that isn't going to work out. Change the Name property of the textbox to txtName or something.

[kimmer]

Uh-oh, I noticed something else. you should not have quotation marks where you have them.
And I imagine you want a comma and a space in there.

=[Last_name]&", "&[First_Name]

[Access_Blaster]

Also, I could use additional help. Basically, what I want is a form that pops up when the database is opened. It will have a list of all the contacts. When one is clicked on in the list box, I would like to have the primary and secondary numbers display in two text boxes at the bottom. I'd like a search bar at the top and maybe some sort options. I'd like to be able to double click on a name and have a second form come up with the complete information on the person. If you could tell me how to go about this, I'd really appreciate it. Do I do an on double click action for the list box or is it something like listbox.item on_double_click. These are the kinds of things I need to know. I know enough to know what I don't know, if you know what I mean. Thanks for all the help.

This should be broken down into separate questions like: How do I create a list box that pops up?

When you get your answer, question (2) could become clear, if not ask another question.


Regards

Richard