New to Forum - Lookup Table help please

  • Thread starter Thread starter miles_muso
  • Start date Start date
M

miles_muso

Hi all

Am new to this forum and pretty new to access. Can u help?

I'm creating a DVD database and want to create a data entry scree
which references a lookup table of Actors and Actresses to avoi
mis-spelt and/or duplicate names. That way, when I run a 'how man
films with Michael Caine in' query, I can be sure that I didn't ente
Micheal Caine, Michael Cane, etc etc when creating the new DVD entry.

I've got the combo box bit working, along with the AutoExpand featur
(which is a nice touch), but if I type a new actor name (ie one tha
isn't in the Lookup Table already), I want the option to add to th
lookup table, rather than get the standard 'not in list' error msg.
know that there's a 'OnNotInList' property, but I'm not proficien
enough (or, rather, at all) in VB to know how to write the procedur
that would follow this event.

I've had a look through a few 'Access for Dummies' books and similar
but they don't seem to cover simple VB procedures.

Surely this is a pretty common requirement for a database, so am
missing something obvious?

Your help would be appreciated.

Thanks,

Miles Forman
(ex-IT training salesman in the UK,
now Keyboard player on Disney Cruise Lines,
somewhere near St Maarten)
 
I know that there's a 'OnNotInList' property, but I'm not proficient
enough (or, rather, at all) in VB to know how to write the procedure
that would follow this event.

I've had a look through a few 'Access for Dummies' books and similar,
but they don't seem to cover simple VB procedures.
Click to expand...

<g> Nope. Dummies don't do VBA... More seriously, that genre of books
is intentionally limited to the very basic techniques; this isn't that
hard but it's a step above the Dummies level.

There's some good sample code at the Access Web:

http://www.mvps.org/access/forms/frm0015.htm
 
Back
Top