UpdateField selected in Listbox

Rince

New member
Local time
Today, 12:41
Joined
Nov 8, 2007
Messages
6
Hi,
I would like to update the fields 'STATUS' and 'STATUSDATE' in the table 'QTHD' for the items selected in the list box 'lstQuotes' when the command button 'cmdDead' is clicked. The fields will populate with the word "Dead" and the current 'Date' (...Now()...) respectively.

I have attached my mdb file.

Any assistance would be greatly appriciated.

Regards,
Sean
 

Attachments

Search Access VBA help for the 'ItemsSelected Property' of the ListBox object. There's sample code there that'll get you started with figuring out what's selected as a first step.
 

Users who are viewing this thread

Back
Top Bottom