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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using table field in Lookup Wizard 3
Referential Integrity for Lookup fields in tables 7
Access Command button to look up and copy data from a query to a table 0
multiple column lookup 1
Lookup Not Working 4
Why can't I find a table in the lookup wizard? 2
Fill in multiple fields with one lookup 0
I need to select a specific lookup list 2

Back
Top