Pedigreeman
Registered User.
- Local time
- Today, 11:27
- Joined
- Mar 14, 2011
- Messages
- 57
I have a table with the following headings
Date | Day | Weight | Start Weight|
When I enter the first date, I would like subsequent dates to enter themselves below for 32 days in this Date column. Similarly in the second column 'Day' I would like it to autofill the Day from 0 - 32 (zero being on the same row as the first date I selected, and 32 being on the same row as the last date autofilled). Also I would like to enter the start date once, and for it to repeat itself throughout the 32 days.
This is for a subform within a form, so for each record I have 32 assigned days. The 'start weight' is on the form itself, but I have no idea how to get this form to communicate with its subform (happy to enter the number manually, but wish it would repeat itself for the following 31 days).
I hope somebody can help - I am fairly new to all of this so please try to explain in laymans terms. This is something I could do fairly easily in Excel, but I know that Access works differently.
Many thanks in advance.
Date | Day | Weight | Start Weight|
When I enter the first date, I would like subsequent dates to enter themselves below for 32 days in this Date column. Similarly in the second column 'Day' I would like it to autofill the Day from 0 - 32 (zero being on the same row as the first date I selected, and 32 being on the same row as the last date autofilled). Also I would like to enter the start date once, and for it to repeat itself throughout the 32 days.
This is for a subform within a form, so for each record I have 32 assigned days. The 'start weight' is on the form itself, but I have no idea how to get this form to communicate with its subform (happy to enter the number manually, but wish it would repeat itself for the following 31 days).
I hope somebody can help - I am fairly new to all of this so please try to explain in laymans terms. This is something I could do fairly easily in Excel, but I know that Access works differently.
Many thanks in advance.
