I have multiple tables pretty much all linked by a Room ID.



The input/edit form updates information in the form based on a combo box that the user selects the Room ID with. All the other text boxes, check boxes etc. populate automatically.

When the user changes any of the parameters the corresponding table should be updated. The problem is I can't figure out how to get the UPDATE code to work.

Question #1 - Is this the completely wrong approach?
Question #2 - How do I reference the current selection in the combo box when writing a sub routine for another control? I tried the text property and the value property, but that approach keeps returning a value instead of an actual text string.