Criteria carried over

[goaksmith]

I have a main form with several subforms. The main form is linked to a query which asks you to select a code which relates to a specific company. So when you load the form it asks you to enter the company code (ie CA for Company A).

Some people at my work are printer happy and want to have a piece of paper which has the same information on it. So what I have done is for all the subforms is create a command button which will open a query. The query asks again for the company code and then brings up the information in a table form which is a little easier to print.

This way will work fine, but I was wondering if there was a way to carry the company code over from one query to the next until the form is closed so that it doesnt have to be typed in again and again.

 

[Fornatian]

Th easiest way to install persistent criteria is to put a combo box on your form for users to choose criteria, so instead of

[Enter the Company]

refer to the combo box on the form for the value suchas

Forms!MyForm!Combo1

Also, using that method you get reliable criteria if the combo box is set to LimitToList =Yes