My database consist of a main form "Orders" and a subform "Order Details". The subform has several fields including: Quantity, Unit Cost, Product Code, Description etc.
Problem: I want "Product Code" to be the first field so I arrange it like that in the design view, but it does not appear like that in the form view; the Quantity stays as the first field. I have even tried shifting the fields around in the form views and this works but when the form is closed and reopened the "Quantity" field reverts to first position.
Setting the field width is the same problem it revert to original column width.
would be grateful for some assistance