Creating a history subform?

[tlaker10]

Access 2000- my form has fields for “name”, “arrival”, “departure” and
“site nbr”. Can I make a subform under “name” that keeps a history of
all previous entries to arrival/departure/site nbr so that when the main
form is changed, the new information is ADDED to the subform? Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[PC Datasheet]

Yes, just base the subform on the same record source as the main form. The
problem you are going to run into is that all new entries on the main form
must be saved before you can see them in the subform.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"tlaker10" <tl******@yahoo.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

Access 2000- my form has fields for "name", "arrival", "departure" and
"site nbr". Can I make a subform under "name" that keeps a history of
all previous entries to arrival/departure/site nbr so that when the main
form is changed, the new information is ADDED to the subform? Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[tlaker10]

that's what I tried, but all I get is the last entry, not a complete
list of previous entries made in those fields. I linked both tables
together via primary key, is there something I'm missing?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[PC Datasheet]

Don't fill in the LinkMaster and LinkChild fields. You don't want the
subform to track the main form. you only want it to appear on the screen
with the main form.

Also check the recordsource of the subform. You want the subform to get its
records from the same table as the main form but you fon't want any kind of
filter on the records. You may be filtering the main form for some reason
which is OK.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"tlaker10" <tl******@yahoo.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

that's what I tried, but all I get is the last entry, not a complete
list of previous entries made in those fields. I linked both tables
together via primary key, is there something I'm missing?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[tlaker10]

I have 4200 campers, each with their own subform. By not linking the
form to the subform results in a "History" subform of 4200 entries. By
linking the form to the subform "History" with the primary key, I get
only the subform "History" for that particular camper. Naturally, it
doesn't update to a new entry when a new arrival/departure date is
entered in the main form. What I'm looking for is the ability to have
one subform per camper with all new information that is entered in
"Arrival" and "Departure" in the main form to be recorded as a new entry
in the subform "History" as well. Maybe it can't be done?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!