I have created a grid populated with fields from a table called Vac (for displaying Vacation data). I have provided a combo box for the user to select an employee from. The combo box RowSource is from a Master Employee parent table, Prlink, and is related to Vac by Employee nmbr. I now need to provide a way for the user to add a new vacation record for the selected employee. I placed a cmdbutton on the form with the caption Add A Record. Is there any way I can just append a blank line onto the bottom of the grid and let the user type the data in right then and there. I have already tried the following in the cmdbutton.valid with no success (except that it indeed does append a blank record which I can't seem to see on the grid, but I can see from the status bar that a record has been added).
SELECT Vac
APPEND BLANK
ThisForm.Refresh()
Any help would definantly be appreciated. Thanks, CH.
Chuck Henry