carrying data from one form to another

[mic907]

My database currently has a form with 2 subforms. The main form is the ConsultantList with a ConsultantID. This ConsultantID is carried over to a Contract subform when data is entered into the subform. This Contract subform also has a ContractID number that then carries over to a Services subform when data is entered into there.

I want to get rid of this subform within a form structure, and replace it with several linked forms with buttons to open the following form (ie The ConsultantList form will have a button to open up the Contract form). However, I cant figure out how to get the above data (ie ConsultantID, ContractID) to carry over when I have this structure. Does anyone know how to do this?

I made my subform structure (the one i first mentioned) via the Access wizard. My primary keys are ConsultantID (ConsultantList form), ContractID (Contract form), and ServiceID (Service form). If there is any other information needed, ill be happy to give it.

 

[Dreamweaver]

There is an option in the Forms wizard that will allow you to either create a form with subforms or one with a linked forms.

Mick

 

[dervly]

There is an option in the Forms wizard that will allow you to either create a form with subforms or one with a linked forms.

Mick

Is this option available when you create the form in the wizard? or how is it accessable?

 

[CEH]

It is in the wizard.... You pick the option. Make sure your form is from a query, and at least two tables in the query.

 

[mic907]

I've tried this, but like I said the autonumbered primary key values are not carried over