Do you remember me for Data Control & Listbox ? Help me again now, please!

Hi there,
I am very happy to find many people help me here.
Last month someone helped me to get personal information
from a person selected in the listbox.

The query string was:
Data1.RecordSource = "SELECT * FROM Engineer WHERE [Last Name and First Name]= '" & DBlistbox.Text & "'"

Now I would like to delete the selected Engineer and
be able to undelete it.

In addition I would like to modify the personals information; to visualize them I use some textboxes with DataSource=Data2 and DataField = the respective field.

I can write in the texboxes, but I would like to store the changes only by pressing the CommandButton "Modify"

-----------------------------------------------

THANK YOU for all; write me as soon as possible!

-----------------------------------------------

PS
Data1 is = Data2, but I need two different controls; it's ok.

[Edited by stefano on 10-29-2000 at 03:07 AM]

[makai]

Stefano

the way to delete the current record is:

Data1.Recordset.Delete

however if you wish to undelete it, you must save it somewhere - perhaps in a second table named differently with identical fields - you would then be working with 2 recordsets (or 2 Data Controls)

If you wish to store changes to a database only when a commandbutton is clicked, then the textboxes would not be bound to the data control

Private Sub Command1_Click()
Data1.Recordset.Fields("firstfield") = Text1
End Sub

it is difficult to answer your question more fully without writing an entire application

Rick

Thank you very much. I think I'll do as like your answer.
Maybe I must work without bound the textboxes.
I do it now, because tomorrow I'll show the program at
the school.

[johnnyboy23]

im having a simular problem but my problem is this
i want to display the information from my SQL7 database in my dbgrid control how do i set my setting n the control data1 to see my SQL database???
please help i have been asking evryone for about 2 weeks
thanks
john

Hi johnnyboy23, you didnt write what exactly you want to show in the dbgrid. The entire database means what. Is it the tables and the fiels in them or is it a table and data in it. You should be clear with ur requirement before anyone can try to help you. All the best...vijay

Hi there,
the teachers have been proud of me for the work done.
Many thanks to everyone helped me.