Access 2000 visual basic language event procedure

  Plummers 14:33 15 Feb 2005

"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



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 ?