Using combo box to add one name

[windwardmi]

I have a combo box on a form to add an assigned employee to a project. The row source is a query. the qryEmployeeNames has fields: Employee Number, Name: [First Name] & " " & [Last Name], and Title from qryEmployees that querys tblEmployees.



All that showes in combo box on form is Employee Number. I want the complete first and last name to show up instead.

[windwardmi]

Have I done something wrong to not get a a reply to my question?

I was hoping this question could be easily answered. I pretty much followed an example from similar database file and still have no luck geting the actual name instead of auto number to apear in combobox.

I admit I'm a beginner but I'm trying to grasp the concept of access.

[Datagopherdan]

You need to set your column widths in your combo box. If you just want the Employee Name to display, which is the second field, you would have to set the combo box to have 3 columns and the widths to be something like 0,1,0. This would cause the ID and Title not to be displayed. Only the name would be.

Dan
Access Development

Have I done something wrong to not get a a reply to my question?

I was hoping this question could be easily answered. I pretty much followed an example from similar database file and still have no luck geting the actual name instead of auto number to apear in combobox.

I admit I'm a beginner but I'm trying to grasp the concept of access.

[windwardmi]

I hav been stuggling for days to learn this simple answer myself. I'm back to reading and learning.


Your suggestions on any learning tools or online school would be appreciated.


Thanks for your help to solve this issue.

[Datagopherdan]

Theres alot of good resources for learning Access such as these boards. You can also google for access training, examples, tips and tricks etc, which will provide you with alot of resources.

Good luck

Dan
Access Development

I hav been stuggling for days to learn this simple answer myself. I'm back to reading and learning.


Your suggestions on any learning tools or online school would be appreciated.


Thanks for your help to solve this issue.