S
Simon Dowse
Hi,
Not sure how complex this might get, but stick with me!
I have a spreadsheet with a load of headers, the ones I am
concerned with here are 'Cause' and 'Wish List', basically
because there are 40 of each, all with a separate column.
What I have done is link the spreadsheet to a table in
Access, and created a form using the table. Within this
form there are 2 subforms, 'Cause' and 'Wish'. Basically,
there are 40 rows in the 'Cause' subform and the same in
the 'Wish' subform, all bound to the main table in
Access. The problem is that when I enter information into
the subforms it doesn't show up when you close and re-open
it, and they're on separate rows in Excel. Where am I
going wrong? I'm guessing it has to be linked some how so
that Access know that when I enter something into 'Cause'
in the subform for record reference 1, it will always show
up in that record, and not in any others?
Any 'easy to do' ideas?
Not sure how complex this might get, but stick with me!
I have a spreadsheet with a load of headers, the ones I am
concerned with here are 'Cause' and 'Wish List', basically
because there are 40 of each, all with a separate column.
What I have done is link the spreadsheet to a table in
Access, and created a form using the table. Within this
form there are 2 subforms, 'Cause' and 'Wish'. Basically,
there are 40 rows in the 'Cause' subform and the same in
the 'Wish' subform, all bound to the main table in
Access. The problem is that when I enter information into
the subforms it doesn't show up when you close and re-open
it, and they're on separate rows in Excel. Where am I
going wrong? I'm guessing it has to be linked some how so
that Access know that when I enter something into 'Cause'
in the subform for record reference 1, it will always show
up in that record, and not in any others?
Any 'easy to do' ideas?