Sabrina has attended:
Access Advanced course
Queries on Forms
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
RE: Queries on Forms
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
