courses in microsoft access - queries forms

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum 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

resolvedResolved · 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


 

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Server loaded in 0.08 secs.