Combo Box Problem

[dccjr]

I have a form containing a combo box. I need the selection in the combo box to determine which table it writes the form data to. Any help would be greatly appreciated.

dccjr.

[June7]

Why would the form write data to different tables. Sounds like data structure might not be optimized. Want to provide db for analysis? Follow instructions at bottom of my post.

[dccjr]

Thanks for the insight. I restructured so that all of the data is together. Problem solved (but several others have arisen). Let's call this one solved.