Subform Problem

[digs]

I've got a main form called contract_input with a subform called contracts. This is were new contracts are entered and then there are three options of getting paid.
What I'd like to happen is when the data inputers pick an option it moves to a new main form called contract_sessions with a subform called session_contracts using the field of contractid which is on each subform.
I'm having problems with the code. I can get it to open using a field on each main form.

Can anyone help?

 

[godofhell]

Can you post a copy of your database. I got lost reading your description.

 

[Haymarket]

Not sure if you are trying to overcomplicate the data input, from your description. Seeing the database would help.

Have you considered using tabs, so they start at the left tab sub form, and move to the next one. Then all you need to do is requery the sessions subform when the contracts info is updated.

 

[RV]

digs,

seems to me you're overcomplicating matters.
The only data group you've got is contracts.
Therefore, you need just one form, using listboxs in the form header to query on existing contracts.

RV