sub form criteria

  • Thread starter Thread starter Steve G
  • Start date Start date
S

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
 
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
 
Back
Top