I have added a function to insert an item code into a new sales line from the sales order form. Basically the user moves t oa new line, hits F10 and then is presented with a filtered list of items. (I can’t use the normal “no.” field lookup).
The problem is, however , that when the user selects the item required and returns to the sales order, the new line has been inserted correctly at the bottom of the current sales lines but the system sets the record pointer to the first line. How do I get it to select (set the pointer) the line I have just inserted?
The F10 function on the main form calls a function on the subform…
… which in turn calls a function to insert the new item line.
I don’t want to create a new record as soon as the user moves to a blank line so any ideas would be much appreciated.