Updating a Mulitple Queries

[cocoonfx]

Hello I am new to Access and slowly finding my way round.

I have built 30 queries which eventually build two Union Queries of which each query as a slight different criteria.

In all 30 queries there is an indentical Field name called Arrived. What i want the user to be able to do is change the criteria in the Arrived figure throught a message box. So far the criteria is in the field is:

>=date()-3

This will show me everything 3 days ago. What i want to do is to let the user check what happened 5 days ago 10 days ago. I know i can create the following to solve the message box:

>=date()-3-[Enter in the days less than today]

Is there away to update all 30 queries at once with the same code?

 

[neileg]

Caputure the user input in a form control and use the control as the criterion in all 30 queries.

I suspect you have some design problems if you need to union 30 queries, though!

 

[cocoonfx]

Help?

Ok so i would have to create a form but would how do i link the text field to the "Arrived" Field in each query??? I am new to Access so if you could point me in the direction on how to start this, as i have search the forum for hours to see if i can get a clue.

Fortunately the 30 queries is a small amount considering how many business rules i have to apply to the database i tired combining them all into a couple of queries but the business rules are very very complicated! )

 

[neileg]

Suppose you create a form called frmMyForm. Create a text box with a name of say ctlMyControl to capture the number of days back you want.

In the criteria box in your queries enter:
>=date()-[forms]![frmMyForm]![ctlMyControl]