I have a form that allows users to add a Location value not in the form's combo box drop down list just by typing it in and requeries so it appears. The added value does appear in the detail table from the form but does not appear in the Location table. How do I make that happen?