Help needed: Opening a specific form using Visual Basic

[joolsUK0575]

Hi there

The basics of it are this.

I have a main form entitled BAR_frm. On this form are 7 fields for an address named as follows:

mainsite_organisation
mainsite_address1
mainsite_address2
mainsite_address3
mainsite_address4
mainsite_address5
mainsite_postcode

I have a seperate form fronting an address table (called Address Map) this form is called AddressMatch. This form has the same amount of fields as above and are also named the same.

What I need to be able to do is this. I need to have a button on BAR_frm that will open up the form AddressMatch when the text entered into BAR_frm matches the contents of the form AddressMatch.

So, say if I enter SP1 3AH in the field mainsite_postcode on the form BAR_frm then it needs to open up the form AddressMatch.

I am able to this using a macro, but i need the button to go look through all the fields not just one.

The code I have for just one is:

DoCmd.OpenForm "AddressMatch", acNormal, "", "[Address Map]![mainsite_postcode] = [forms]![BAR_frm]![mainsite_postcode]", , acNormal

It would be most appreciated if someone out there could lend a hand

Thanks

Jools