Data control

[sborny]

Hi,

I have a datacrontrol called data1 and a textbox that is bound to the control. The control loads an access db and displays email addresses in the text box.

I am trying to find out how to delete the currently selected email address and to then refresh the data control.

Can anyone help.

Cheers

Sborny.

Everything has an answer, it's just knowing the right question to ask. !!!!

 

[Glasgow]

I don't tend to use data controls but can't you just use:

data1.Recordset.Delete

 

[sborny]

Hi Glasgow,

Would you be kind enough to tell me how you would do it without data controls.

Thanks

Sborny.

Everything has an answer, it's just knowing the right question to ask. !!!!

 

[Glasgow]

I declare and populate a recordset as you may well have done yourself already then, for example, bind the textbox to that recordset.

Set Text1.DataSource=RsMine
Text1.DataField="Email"

Of course, without a visible data control, you need some other mechanism to allow the user to step through the recordset. I use a DataGrid control for that.