Scroll Box intermittantly does not populate window

[pcervi]

I have a window that is pulling from a single table. In the scroll box at the top I am using a select query listing project titles from the same table, and have the form set to populate the body of the form when the title is highlighted in the scroll window. This works most of the time. However I am finding occasions when I will highlight a title and it does NOT populate or change the data in the window. I can find no smoking gun as to why this on occasion will fail. Always busts on the same records. Can find no difference field property wise with the data.

Anyone have any clues?

Thanks,
Pete

[John_G]

Hi -

By "scroll box" I assume you mean "combo box"?

How are you populating the body of the form when you make a selection from the combo box? Since it always fails on the same values, it suggests there is a data problem you are not aware of.

Can you post the SQL for the combo box source, and the VBA you are using?

John