How to add an entry in the lookup table

  • Thread starter Thread starter BigBadWolf
  • Start date Start date
B

BigBadWolf

Hi

I have a table with a few entries that i use as a lookup in another
table. It works fine as long as the data is in the lookup table. If it
isn't I can still add it manually. I want this to be automatically
added to the lookup table also.
Any ideas?
tx
 
Not possible in the DatasheetView of the Table that has the LookUp Field.

You need to use a ComboBox on the Form and use the NotInList Event of the
ComboBox.

Check Access VB Help on the NotInList Event.

Beware that LookUp Fields can create problems for you if you are using
LookUp Fields. See The Access Web article:

http://www.mvps.org/access/lookupfields.htm
 
Back
Top