data to grid (1 Viewer)

[JoeAcess]

Hi everyone

I am using VB 6 on the front end and access 07 at the back. i have a form. The form contains patient details. the pat id is the primary key. so one form per patient kind of thing. It also has two fields called test and test result. for a patient there might be atleast 3-4 test. so i would like each test to be entered. i want each of these that is entered to be on a grid. this grid should also be in the same form and the field should be cleared so that new test can be entered. i should also be able to delete a row on that grid. How can this be done. should i make a separate table for test and test results.

Thanks a lot in advance

 

[Uncle Gizmo]

>>>should i make a separate table for test and test results<<<

yes I think that would be a good idea, then create a form viewing that new table in datasheet mode and add this new form to your existing form as a sub form.

 

[sidharth]

This is possibly done by create a table and create a new grid.and type the coding which you can take or learn from vb tutorial.Its long query that's why i forget some code but you can view from any vb tutorial..good luck..