combo box that does not show full name how do I fix?

[asoe209]

Hi all quick bit of help needed if passable, im sure this is a simple fix but just not worked it out yet.



I have a table and form, and one of the data entry parts of the form is supervisor name. I set this up as a dropdown list. I guess I must of choose the work set up when I made it as when I select a name it only pulls through the first name and not the surname. I.e. if John Doe is selected it only input John into the form even through on the dropdown list its showing the full name.

This is coursing problems when sending reports as there are a number of people with the same name. I just can’t work out how to correct this as I don’t want to mess up my DB as its in use now.

[TG_W]

Is the supervisor name in two different fields? If so, the solution would be to have both fields bound to the box. In the 'Data' tab of the 'Properties' window, you can see where the bound column is and make alterations. You could also do a quick 'AfterUpdate' VBA fix - Me.ComboBox1 = Me.ComboBox1.Column(0) & " " & Me.ComboBox1.Column(1).

[asoe209]

The supers name is in one field. But you know when you click the arrow to show the list well that list shows first nae and surname. but once you select the name it it only brings i the 1st name.

On the table for supers there there names are in sepreat fields.

[TG_W]

So where is the combo box pulling from?

[asoe209]

combow box is pulling fron supervisiors table. from field names:
FirstName
Surname

just does not input the surname into field.

[TG_W]

Ok. So have you tried the code I posted changing the combo box name to what yours is in the form? That should resolve the issue because it sounds like you are pulling two columns of data and the first column is the one bound to the combo box.

[asoe209]

where and how do i add this code I will give that a try.

[TG_W]

In Design View, left-click on your Combo Box to select it. If it is not open already, open the 'Property Sheet' (in the Ribbon or press 'F4') and go to the 'Event' tab. Left-click in the 'After Update' box then left-click the "..." on the right of the box. Select "Code Builder" then press 'Ok'. Copy the code I posted and change the Combo Box name to the one in your form.

[asoe209]

is this in the tabke design view or form design view. as in form design I can see any info in the sup form which is where this is based. it just ahow a white box.

[TG_W]

Form Design View

[asoe209]

HI again as I have not been able to work this out I have atached screen shots of what I get.

As ou can seen in Image 1 in design view I cant view the contence of the table to make the canges as suggested. image 2-3 show the form in its normal view and how the names are displayed when selected.

[TG_W]

It appears you have simply drug your table into your form, which you did not note before and is a fairly important piece of information you left out. Can you post your database with your data stripped out for further analysis?