Moving unbound combo box selection to a field

G

Greg

Hi hope someone can help me here.

I have an unbound form (MyForm) used for data entry. On it is an unbound
combo box called SelectThing with 2 columns, IDCombo and NameCombo. I have
another control, (not sure if it should be a subform or what??, lets call it
SelectedControl). I also have two buttons, AddButton and RemoveButton. I
would like to select an entry in the SelectThing, Click the AddButton and the
selected record in SelectThing appears in SelectedControl. If I select
another thing in SelectThing I want to be able to add it also, but never
more than one of the same selected things. Also, working the other way
around, I would like to be able to select an entry in SelectedControl, click
the RemoveButton and the item is deleted from SelectedControl. If this is
possible, I would then click my Save button, which creates a new record in
MyTable, assigns an ID and saves my selected things.

What is stumping me is the fact that I can't see a way to relate
SelectedControl and MyForm until MyForm is saved.

Also I need to do this for lots of different types of selected things so I
would like to be able to Call the routine for each instance. Any help would
be greatly appreciated.
 
Top