Hi everyone, Im hoping someone can help with this.
I have a Splitform"Stocktable" and it has a subform "StockMove"
(The splitform only displays the datasheet half and the individual fields are hidden)
A user will select a line/record in the Datasheet and relating stock moves appear in the "stockmove" subform.
There is a new record button in the subform
I have noticed that if a user is editing a field in the parent form "location" field, but they have not exited/moved to another field then the "New Record" button applies the new record to the parent form "StockTable".
Im trying to understand if there is away i can "save/Update" that field so the New record button in the subform does not accidently create new record in the parent form?
(the purpose of this form is that people select different stock lines and can create new stock movement relating to them in the subform so if the new record applies to the parent form, there is potential for people to create stock moves that do not relate to any stock)
Thanks in advance and let me know if you need any further info etc
I have a Splitform"Stocktable" and it has a subform "StockMove"
(The splitform only displays the datasheet half and the individual fields are hidden)
A user will select a line/record in the Datasheet and relating stock moves appear in the "stockmove" subform.
There is a new record button in the subform
I have noticed that if a user is editing a field in the parent form "location" field, but they have not exited/moved to another field then the "New Record" button applies the new record to the parent form "StockTable".
Im trying to understand if there is away i can "save/Update" that field so the New record button in the subform does not accidently create new record in the parent form?
(the purpose of this form is that people select different stock lines and can create new stock movement relating to them in the subform so if the new record applies to the parent form, there is potential for people to create stock moves that do not relate to any stock)
Thanks in advance and let me know if you need any further info etc