Harry,

>I faced a main problem in my program designing for a small resturant. A grid control is used for taking orders which is linked to a database. After entering menu code and quantity for a record the cursor stays in the same record. I have tried several ways to move the cursor to next record for new entry but failed. I would be very grateful if anyone could give me a hand.

When appending records, it may be wise first to get the focus OFF the grid, Append the records and set the focus back on the grid. Especially where there are validation rules in the object within the grid you'll ecounter some difficulties to get the grid working properly.

In my projectclasses I have a extra textbox (which is not visible because it has a X-position of -1000) which is used when I must get the focus of the grid in the following manner:

AddRecord method for the form:

THISFORM.txtFocus.SetFocus
SELECT (THISFORM.DefaultAlias)
APPEND BLANK

...

THISFORM.Grid.SetFocus

Ect..


Walter,