just wondering

[Miethr]

Is it possible to use a combo box to select a value and change where a form updates a table based on which value is chosen?

My thought is to have 1 form to input data, but there are 4 different tables I would want to update and which table is updated is based on what value the combo box is.

Just wondering


Riley

Newbie who is finding the joys(and sorrows) of access quite a bit of fun!

Cheers!

 

[Banana]

You will need to tell which table you want to update.

Cascading comboboxes should do that for you. Search the forum on that; there's two or three example of that.

HTH.