Databases and recordset

[dfg]

Hi. I am doing some basic database stuff - read, add, delete, change etc.

The database contains names.

One of the things I'm trying to do is whenever I delete an item from the
database is to show a message box with the the current name of the
record I'm deleting...Kinda like so:

intRetValue = MsgBox("Are you sure you want to delete " &
adSaleData.RecordSet.????? & " from the database?"

Any ideas?

Thanks.

[dfg]

dfg wrote:

Any ideas?

Sorry guys, I figured it out.

[JR]

dfg <df*@dfg.net> wrote in message news:<YGDvb.454594$pl3.191261@pd7tw3no>...

Hi. I am doing some basic database stuff - read, add, delete, change etc.

The database contains names.

One of the things I'm trying to do is whenever I delete an item from the
database is to show a message box with the the current name of the
record I'm deleting...Kinda like so:

intRetValue = MsgBox("Are you sure you want to delete " &
adSaleData.RecordSet.????? & " from the database?"

Any ideas?

Thanks.

Put the name of the recordset followed by the column number where the
name is in your database.

example: msgbox namerecordset[4] => The fifth column value will
display his value now