sub form criteria

[Steve G]

Hi All:

Is it possible to open one of several possible forms based on criteria in
the main form?

For instance, I have a form and one of the fields is "type". Based on the
type selected, when the form completes, can I click on a command button, and
have another form open based on the "type" selected in the first form?

Something like If me!form!type=new then open newForm?

Steve G

 

[Steve G]

I should have added that I have a field value in the first form (separate
from the type value) that needs to automatically fill in in the new form;
i.e., the value for custID in the first form must also be in the second
form's custID field.

Steve G