Continuous forms

[jamesd]

How do I prevent the header data changing for each new entry in a continuous form.
I would like to enter the header data once and then each new record on the detail will take the data from the header .
The reason for this is I have a form that is limited to 10 records, the user enters his/her name and a ref number then fills in the 10 records , but the user and ref is the same for each record .

All this data needs to be recorded in a table

Hope this is not to confusing

 

[Trevor G]

You could use 2 tables and relate them,

Headers then stay in one table and the data stays in a separate table.

The relationship would be 1 to Many and you can then run queries etc to see the person and records from both tables.

 

[Norie]

You could make the input fields unbound and once something has been entered in them they can be used for the default values of the new records.

By the way, why are you creating the 10 records/ids before any data has been entered?

 

[boblarson]

If the user and ref number is the same for all of the 10 records then your table structure is incorrectly set up and you should have a header table which would capture that information and then the rest of the non-repeating fields would be in a child table (using a subform). You should not be storing the same data over and over again for a set of records if it is always going to be the same like that.

See the Northwind database example and the relationship between Orders and Order Details for a guide on how that would work.