98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » courses in microsoft access - Queries on Forms
courses in microsoft access - Queries on Forms
Resolved · Low Priority · Version Standard
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Duplicating an EntryTo duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field. |