Access 2000 visual basic language event procedure

  Plummers 14:33 15 Feb 05

"OnNotinList" Event Procedure

What would be the necessary visual basic programming inputs' to automate data entry when data is not in the relevant table and field.

  AccessMoron 17:36 16 Feb 05

dim ctrl as control

response = acdataerrcontinue

set ctrl = [name of combo box]

if vbyes = msgbox "Do you wish to add " & newdata & " to the list?", vbinformation + vbyesno, "sys admin" then

write the ado code to insert into table

response = acdataerraddded



end if

This thread is now locked and can not be replied to.

How to watch Windows Event live stream, live blog | Microsoft event live stream: Watch Microsoft…

1995-2015: How technology has changed the world in 20 years

This amazing app turns your iPad Pro into a Cintiq

iPhone 7 Plus review: A superb big-screen phablet, but the price tag's enormous | iPhone 7 Plus…