By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,649 Members | 1,560 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,649 IT Pros & Developers. It's quick & easy.

Creating a history subform?

P: n/a

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!
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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!

Nov 13 '05 #2

P: n/a

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!
Nov 13 '05 #3

P: n/a
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!

Nov 13 '05 #4

P: n/a

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!
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.