What i have is 3 combo boxes on a main form which basically filter out choices for 2 combo boxes on a subform (combo_code & combo_title).

When combo_code is selected it finds the relavant title in combo_title or vice versa.

What i want is the subform to list codes and title already selected, plus the ability to to add more items to the subform with the combo boxes on the subform being updated to reflect information entered in the combos on the main form. This again I am able to do.

The problem I am having is retaining the title information held on the subform when the data in combos on the main form is changed. I think it is due to different choices being available and it only showing info when its available in the combos on the subform.

The weird thing is though it doesnt matter what changes I make on the main form the information already stored in combo_code stays present regardless and if i go to add new information the updated list is shown as it should. But when i change the information on the main form, information already stored in combo_title blanks out, but the drop downs are populated as they should.

Change the combobox SQL when you enter into it and have it show all choices when you get out

making combobox sql
http://www.utteraccess.com/forums/showflat...p;Number=722735

basic SQL syntax
http://www.utteraccess.com/forums/showflat...p;Number=774866