RE:Visual Basic Problem

[yinyin]

Here is my problem. Will be very happy if someone can help me. Thank in advance.

1. Well I have this form named frmHistory1. I connect this form to the database using adodc. The function of this form is to show all the previous records of a particular member once I choose the member from the data combo box. On this form I have another button where I view the next data of that member. In this next button I have the coding for updating also. Inother words, the next and updating command is both on the same command button. The problem now is that when I search for the records and update it to the database, it is fine the first time. Nut when I repeat it again it update to the databse again. Meaning it is duplicating the records. So any idea how I can update it to the db without repeating it.
(Note: Initially, I was using data grid and it work. The problem is I dont know how to call it to the data report. If you know how please show me some guidelines. I want to show only the report of the member I choose everytime.)

2. In this last problem will be to call a specific records from the db and post it to the data report.
Well that is all. I hope to hear from you soon. Thank in advance.:)

Recordset.Add

change it to

Recordset.Edit


Hope it helps

[yinyin]

Well, it did work but what about the second problem. Any idea. Thank in advance.

1. Well I have this form named frmHistory1. I connect this form to the database using adodc. The function of this form is to show all the previous records of a particular member once I choose the member from the data combo box. On this form I have another button where I view the next data of that member. In this next button I have the coding for updating also. Inother words, the next and updating command is both on the same command button. The problem now is that when I search for the records and update it to the database, it is fine the first time. Nut when I repeat it again it update to the databse again. Meaning it is duplicating the records. So any idea how I can update it to the db without repeating it.
(Note: Initially, I was using data grid and it work. The problem is I dont know how to call it to the data report. If you know how please show me some guidelines. I want to show only the report of the member I choose everytime.)

2. In this last problem will be to call a specific records from the db and post it to the data report.
Well that is all. I hope to hear from you soon. Thank in advance.:)

Am using vb5 sp3, as such the only standard report format is Crystal Reports 4.2. Are you talking about this or the MS report control shipped in vb6. Wehave just scored version 6 to fix a specific problem, but have nit used the new report control, (hoping to preview it tonite)>:):)

[yinyin]

Well the report I am saying is actually the data report in vb6. You can get that from project-components-designer tab-data environment, data report.

Well that is where I want to post my reuslt to after I call a specific record. Any idea. Reply me for more enquiry.