Add Combo or list box to a form

[Bob Paup]

I would like to add a combo or list box that takes or adds values to a table
other than the one that is the table that the form is working with. I've
tried lots of cominations but haven't found the wining combination. I am
working with access 2003.

 

[Beetle]

Can you describe more about what you are trying to achieve?

Typically, if you need to work with data from related tables, you
use a Form/Subform and the combo/list box would be placed in
whichever one is appropriate to the table you want to store the
data in.

_________

Sean Bailey

 

[Bob Paup]

When I add the subform to the form it comes up with an error when I try to
open the form and says I am trying to delete the table that the subform is
based upon because it is participating in another relationship. I don't want
to delete the table -- I want to either agree with the table values or change
them.