Query matches first record

T

Trillian

On my Contacts Add/Edit form I also have a list box that
will display matching data for each contact that exists in
another table. It's populated with a query linking to the
contactID field on this form.

Before any new contact record is actually "added" - while
I'm on the form entering data - that list box displays all
matching data for the Contact with contactID field =1.

This is essentially only an annoying display problem as
the box displays nothing once the record is saved or
correctly displays matching data once some is added - but
why do new records (not yet saved) match record 1?

TIA
 
Top