automatically adding addtional rows .

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

I have a subform on a main form. How can I automatically add rows with the
same
data in the first row to the additional rows with only the date in the
additional rows changing.
For example if I add five rows the dates would be
12/1/05,12/02/05,12/03/05,12/04/05,12/05/05.


Floyd
 
If this is always the case and every record date in your subform should be
going up like that then perhaps autonumber the field on a table level
already...
 
If all the rows are identical except for the date, create a separate table
with everything in it except the date, then a table with the date and a key
from the first table. That way you don't have redundant data storage, but a
query will display what you want without violating data normalization rules.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top