I have created two queries, first for bank accounts and countries and the second for bank contacts and countries. Both queries have a Find function based in the country field. I have created a form with the two page function, the 1st page form being made up of country bank contacts and the 2nd page form being for country bank accounts (I wanted this form to show accounts via datasheet i.e. all accounts on the one page). The form works fine however as both queries have the find function when the form opens you have to type in the country twice to show the data. Is there anyway that I can just have one find function via a macro?
Thanks

try typing this wild card querie

Wildcards allow you a degree of flexibility when specifying criteria. When you don't know exactly what you are looking for you can use wildcards to give the query a "clue".

For a single wildcard:

Like [type prompt here] & "*"

this will show you all your data