Linking forms assistance

[mattpearcey]

I have a database that holds infomration on banks. I have a mina table that holds most of the core information. I have been asked by on eof my users to incorporate a form that shows country information. Country is one of the fields that is contained in the main table.

So - ive made up a new table 'CountryInfo' and populated it with the fields that were requested. I have then made a new form, inserting all the fields where i want them. Then i went to the control source for the OCuntry field at the top of my form, and inserted the following:-

=[Forms]![Bank Details].[Country]

This make it so that when in the main form, if i am looking at a bank in Cyprus, i click the button i created to go to that form, and it will come up with Cyprus. Ok i have two issues.

A) I cannot get it to come up with the COuntry and stick with that country. For example, when i enter data on say Poland. I wil then go back to the main form, scrol to Ukraine and bring up country info and it will have the info for poland. So how do i get it all to relate to the specific country?

...and...

B) I would like to have a list box present on this form that will popuilate with all the bank names that are for that country, so that i know what banks are in the counry without scrolling through them all. I would also like to hihglight one of them in the list box and then click a button to jump back to the main form with that bank as the record on show?! But i am unsure as to how to do that.

I am pretty sure this is not too hard, but i am running a blank and owuld appreciate some assistance?!

Thank you for your help already.

Matt Pearcey

 

[mattpearcey]

Another thing i would like to incorporate, but have had not got into yet, is inserting a flag and/or map on a tab for each country for this form. I knowi have to put a bound picture frame in, but i have tried to insert this picture but it goes when i exit the form.

Help?

Thank you for your help already.

Matt Pearcey