Mucked Up Combo Box

[Lou_Reed]

In the following db that is contained in the file that is attached to this email the form, frmEmail, has some issues.

The first is when the form opens there is a list of employee name selections, but there is only one employee that can be selected : Boris Karloff.

There are many more, bit only Boris Karloff is capable of being selected, select any other employee and the combobox will not let you.


Now for the weird stuff: if one runs through the meeting dates (there is a next and previous button below Employee name cbobox), the employee selected changes when the meeting_date does. That simply should not happen.

Again, when the meeting_date changes so does the employee name at the top of the list.

There is something wrong here and I do not know what it is!

This post was posted before, but I got no reply so I am posting it separately.



Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

The combo is bound to the FullName field, which is a calculated column and can't be edited. I'd think it would be bound to the ID column.

The form is bound to a query, the combo shows the full name from the record in the query you're on. Why would you expect that not to happen?

[Lou_Reed]

Thanks, I will check it out. Thanks very much for your help.

The way to fix is to change the field that the combo box is bound to? Bind the field to the ID Column as you say.

Respectfully,

Lou Reed

[Lou_Reed]

When you are counting rows when creating a combo box, is the first row 0 or 1?

Also, if you can make selections, but are not allowed to put them in the combo box. How can you fix that?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[Lou_Reed]

I got the first part of this one. The first column is 1 not 0, in a query and in selecting a bound column in formatting a combo box.

However, there are instances in column numbering in MS Access that the first column is 0. Which ones are those?

Any help appreciated. Thanks i advance.

Respectfully,

Lou Reed

[Lou_Reed]

In the attached file is a db, that sort of works.The second employee combobox the lower allows one to select an employee and then add it to the from, frmEmail.

Th unique value is emailaddress. I do not even use auto-number here as the emailaddress and it uniqueness does just fine. However, when I enter the employee name shown completely in the drop down menu, only the first name is added. i want the first and last name. I made the last name column 2 and the third column 0 length it holds the email address, but both columns 1 and 2 have a length.

What do I have to do to show last name in selection?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[pbaldy]

I'm not sure what you're saying. The first field (column) is 0, as the Column property is zero based. Need to go install a printer, will look more when I get back.

[Lou_Reed]

I assumed the first column was 1. It seemed to work. But as I said it n the above post when I use a combo box below the notes on form, frmEmail I have three columns. The first is first name, the second is last name and the third is email address. Email address is unique.

I want the combo box to shows first and last names, it only shows first name. I believe it is because the combo box can only show one selection from a list, not two. That means that I must do a calculated field for full name, but calculated fields are not editable. I cannot select it even if the full name is there, because it is a calculated field.

Somehow there must be a workaround.

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed