This is continuing form my list box question, which i now realise is probably not really linked to list boxes at all!
If i have a field on my form that holds the value of a unique autonumber for another table is there a way i can then do a check on that table and return some other values from that record?
e.g.
my table has 4 columns, (a,b,c and d) i know the value of column a, which is unique.
My form is not bound to this particular table.
What i need to do is check the right table and return the value from column c and d for the record I have the value in column a for.
thanks