Combo Box and Table Issues

[Steven19]

Hi I have a very basic database in design mode at this stage and I have an issue I have not come across before and I am looking for ideas on how to resolve what is going wrong.

Basic issue.

I have a continuation form, All I am entering into the continuation form is a date, and from a combo box an item from the the table linked to that combo box. Simple.

However every time I select an item from the combo box, one of my items changes to a number. so if I pick say item 15 on the list, item 5 will suddenly not longer say "Monthly meeting" instead it will say 11 or 17.

I'm not sure what is causing this.

Other useful information. My combo box has a query behind it, it sorts ascending, and doesn't show the first 4 items in my table.

What could be causing the issue?

[June7]

Certainly something wrong with combobox setup. Without knowing property settings and data structure, hard to advise.

Suggest you provide db for analysis. Follow instructions at bottom of my post.

[Gicu]

Look at the combo's Bound Column property (https://learn.microsoft.com/en-us/of...ox.boundcolumn) and the associated ColumnCount and ColumnWidth properties:
https://learn.microsoft.com/en-us/of...x.columnwidths

Cheers,