Hi, I have situation with 2 user forms - A calls B. Form A just list records, and form B is called to edit single record. Data comes from the database. Simple, works well.
One of the fields is called colour_id and user picks it value from the combo box, which shows 2 columns - colour_id and colour_name, bound to column 1 - colour_id.
As I'm passing colour_id from form A to form B, I want combobox to automatically reposition and show me matching colour_name.
Instead, what happens is that, combo box shows me my colour_id, and then I need to programatically reposition it to matching colour name.
My question is - shouldn't this happen automatically like in Access for example?
Cheers
Jack
Bookmarks