Default records in a Subform - Help

[CD]

I have created a form with a SUBFORM for data entry and I will like the
subform to always open up with 4 default records. Can someone please tell
me how to get this done? Thanks.

 

[Arvin Meyer [MVP]]

I think that you have misinterpreted how databases work. It is never
necessary to store the exact same subform data, or every main form record.
If you need to display those 4 records, build a separate table with just the
4 records and use a non-editable query to display the records in a form or
report.

 

[CD]

Arvin, Thanks for your response. I think you misunderstood my question. I
will be using the subform to enter records into a table but I will like the
subform to start with 4 standard records plus whatever records the user
decide ti add.

 

[Arvin Meyer [MVP]]

Hi CD,

And I think you misunderstood my answer. In a relational database, repeating
rows of data are unnecessary. If nothing at all ever changes. you never have
a good reason to use data over. That's true at a column level as well as a
row level. Since the primary use of a form is to enter or edit data, you
really shouldn't need to see those 4 rows over again. If you do, as in a
report, you can hard-code the rows into the report. In a form, you can build
2 continuous subforms, lock the data for the one with those 4 rows, and
allow editing for any additional data. I can't think of any possibility that
would require the same 4 rows to be continually reentered.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com