You have multiple accounts
Choose the account you want to sign in with.

In a desktop database

  • Build your query, then add parameters. You can add them to Select, Make Table, Append, Update, Crosstab, and Union queries.

  • With the query in Design view, click Parameters (Design tab), enter the parameter, choose a data type, click OK. Then add the same parameter (a.k.a. an identifier) to the Criteria row of the field you want to filter. Enclose second parameter in square brackets.

In a Union query

Add a clause after each FROM statement: WHERE [field name] = [your parameter].Use the same parameter in each clause.

In an Access App

Add your parameter to the Query Parameters dialog first, then place it on the Criteria row. No spaces in parameters or the query fails. Remember, Apps use different wildcards than desktop databases.

Build the first view

Use a blank view with no data source. Add text boxes, apply date/time format, add labels, button, give the controls names, add formatting to taste.

Build the second view

Home> Advanced> Datasheet View. Click Data, select your Parameter query, click Show only fields in the current record source, drag the fields to the view.

Build the macro

On the first view, click the button > Actions> On Click>Open Popup. Under Parameters, enter the name(s) of the text box(es) on the first form, surrounded by square brackets. Save, close, save the database, then Launch App.

See also

Potrebna vam je dodatna pomoć?

Proširite svoje vještine
Istražite osposobljavanje
Prvi koristite nove značajke
Pridružite se Microsoft Office Insiderima

Jesu li vam ove informacije bile korisne?

Što je utjecalo na vaše iskustvo?

Hvala vam na povratnim informacijama!