setting value for combo boxes

L

lefty

i have a combo box bound to a table that when 'not in list' opens a
form to add a new entry to the bound table. once the user adds an
entry to the bound table via the newly opened form, i'd like this
value to populate the original form control, which is still open. and
not to get to greedy, but i was hoping it could be global in that i'd
like one code or macro so i don't have to do it for every combo box in
the form.

any help is appreciated
thanks
lefty
 
L

lefty

i have a combo box bound to a table that when 'not in list' opens a
form to add a new entry to the bound table. once the user adds an
entry to the bound table via the newly opened form, i'd like this
value to populate the original form control, which is still open. and
not to get to greedy, but i was hoping it could be global in that i'd
like one code or macro so i don't have to do it for every combo box in
the form.

any help is appreciated
thanks
lefty
Click to expand...

p.s...i mean i'd of course add the macro, code to each combo box but
would like to populate the active control in the original form rather
than create a macro for each specific code if possible.
sorry for replying to my own message...i'm new and don't know how to
edit it.
 
Top