suggest you remove the combo control for this case. IMHO most often they are better used as controls for criteria. Used in that fashion, anyone can accidentally alter the location by selecting a different value, and they make for a poor means of altering a bunch of records en masse. As a textbox, it would appear as the rest of the form fields (based on pic). You'd use control(s) on the main form or form header as a means of updating, so after making said change, run an update sql for this order and change the location to be the main/header control value and requery the datasheet.
Last edited by Micron; 07-02-2019 at 03:06 PM.
Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.