General information
Category:
Forms & Form designer
Title:
Combobox binding to recno() not key.
I have a form with a grid and a combobox. The grid is bound to LocalView that has PrimaryKey and DisplayCode fields, and has one column showing the DisplayCode. The combobox ControlSource is LocalView.PrimaryKey, RowSourceType 2-Alias, RowSource is LookupView.DisplayCode,PrimaryKey. BoundTo .F., BoundColumn 2. Scrolling through the grid updates the Combobox display, selecting a new value from the combobox updates the grid. I've done this on several other forms and it worked fine.
But this time, the combobox is displaying values for the LookupView's RecNo(), instead of LookupView PrimaryKey. EG:PrimaryKey 44 is DisplayCode CD100; the Combobox displays RecNo 44 (PrimaryKey 65, DisplayCod MT100)
I can't figure out what's wrong with it. I've compared it to other working forms, but nothing seems amiss. Can anyone else see what I'm overlooking here?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only