Access 2000 visual basic language event procedure

  Plummers 14:33 15 Feb 2005
Locked

"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 2005

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

else

ctrl.undo

end if

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

Elsewhere on IDG sites

HP Envy x2 review: Hands-on

Iconic New York graphic designer Milton Glaser on his uplifting new subway posters

New iMac Pro release date, UK price & specs rumours

Comment suivre le parcours du père Noël ?