Selection in combobox overwrites tables

[gvelix]

Hello!,

I need some help (I have attached an example)

I have 2 dependant comboboxes Year that dependens on Partner and Partners that depends on Country that is independant.

The problem is that when you select a year, the selection overwrites the year (1990 for example) with it's ID (5 for example) so, the result is a loss of the original data integrity stored in the tables.

The form also includes a subform, so when you select Country, Partner and year in the mainform, the results is the monthly information in the subform matching that criteria (this works well fortunately).

Another error message that I've got when picking a year is "Update or CancelUpdate without AddNew or Edit"

Your help would be greatly appreciated!

 

[RuralGuy]

I would start by not binding the ComboBoxes. Leave their ControlSource empty.

 

[gvelix]

It worked perfect!

The first problem is solved, thanks a lot!!

Now I'll write code to clear the selections or use the not in list event to try to fix the other issue.

Thanks a again, you've helped me a lot!!

 

[RuralGuy]

Glad I could help.