beforeupdate : request confirmation

[amigofd]

Hello,

I have a form in access with a listbox. Here the user can select a client and that is linked to other information on the form.

But I need an alert "Are you sure?" when the user clicks on the listbox.

I was thinking of doing it like this:

result = MsgBox("are you sure ?",vbOkCancel,"confirmation")

if result = 1 then
'do nothing and continue
else
'prevent the form to be changed
end if

is this possible ?

thanks a lot !
Frank

 

[PHV]

You may try the BeforeUpdate event procedure of the listbox, playing with the Cancel argument.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886