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