Append from form to sub-form

[sour]

I have designed a database to produce a loading chart for the manufacture of cranes.
To cut a long story short I have a form that I have named Switchboard which has two sub forms all of which are linked via a field called [Order Number]. I also have a button to create a new record, I then add a new order number in the main form, what I want at this stage is to press a button and the new order number appends to the two sub-forms.
The sub forms are continuous forms and are not updatable, can this be done.

 

[June7]

You would have to append directly to table then requery subform.

Why would subforms be not updatable? What purpose do they serve if you can't edit data?

 

[sour]

Hi June7 when i say that the sub-form is not update-able i mean i have selected no additions which takes out the new line in the sub form, however it is update-able and has to be.
When i select a new record all lines in the sub-form disappear, what i want is to add a new job number and append (if that the correct operation) to the sub forms.

 

[June7]

If you use the Master/Child Links properties, the OrderNumber should automatically populate in subform as soon as any other value is input to subform.

 

[sour]

Ok the value is put into the main form i have master/child set up the master is the main form the child is the subform, when i add a new record and a new order number the record only goes back to the main table. I have three tables.
Main form control is Table 1 both sub forms control are Table2 and 3 all linked via qry.

 

[June7]

Provide db for analysis. Follow instructions at bottom of my post.

What do you mean by 'linked via qry'? Each form should have only one table in its RecordSource.

 

[sour]

Hi june7 i have three tables, then a series or query s linked by order number to bring all the fields together, theform takes it control for this qry.

 

[June7]

Should not be one source for all 3 forms. As I said, each form bound to one table.

Use a query joining tables for a report.

 

[sour]

problem i have is the one table id part of another system so i have had to add addition tables, it all works perfectly apart from a new record,

 

[June7]

Don't understand. Form/Subform structure I describe should still work.

And if you want to use a combined query to edit records, then need code to add the dependent records. Use an INSERT action sql.

 

[sour]

Ok will double check my master/child and look into insert action sql, this is new to me so i will have to do some research, thanks for your help.