>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.
You should replace the employee number for link purposes.
INSERT INTO vac (vac.empno) VALUES (employee.empno)
Thisform.Refresh()
HTH
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."