dlookup in query criteria 1

[Spaniard]

Hi,
I have a field of values in Table1 that need to be entered into another field in Table2 via a list box. However, the values must be restricted to those that have not yet been entered into Table2. For example, if a user selects and saves a value (from Table1), that value must not be available for the user to select again - it must 'disappear' from their view.

I have been told that DLookup might be what I am looking for, but I don't see how that applies or if it does, where to put it. Would it be in the criteria for the field in the query or in code from an event?

Thanks,
SWK

 

[gol4]

dlookup would return a value but I think you are looking for something like this

If I understand what it is you are asking

set the listboxes rowsource to

select yourindexfieldname from table2 yourindexfieldname where not in (select yourindexfieldname from table2)

will need to custimize toyour needs

or you could base it on a query uing a leftjoin and look for nulls

hope that is what you had in mind

 

[Spaniard]

The query upon which this list box is based has several criteria, so I couldn't set the rowsource as you had suggested but you triggered something in my brain and I am fairly close now...just a little more tinkering and I think I'll get it.

Thanks for the help.

SWK