>I have a grid in a Form displaying details of orders from table orders. The table is indexed by orderno. I added a control in the Grid which allows me to click and display another Form, Frmdetails, for editing the order details. To add new records, I have an "Add" CommandButton outside the Grid on the Form.
>The "Click" code procedure is:-
>go bottom
>lastno=orderno+1
>append blank
>replace orderno with lastno
>do form Frmdetails
>
>Form Frmdetails does fire up but it always show the details of the first record rather than the appended one. What must I do to rectify the problem? Tks
It could be many problems here. The first question: are both forms use the same data session or they have own private data sessions?
Edward Pikman
Independent Consultant