Hi all,

I have a table called Address and a table called Incidents.

I have a form where it displays fields Address1,2,3,4 and a text box Map Reference.

When the form is opened i want it to search through the Address fields on the form (Contained in Incidents table) and find matches in the Address1 field in the Address table. When it find the matches it displays the corrisponding Map reference for the Address (Map ref is contained in the Address table).

Any help appriciated.