Fields in Main Form to Populate Records in Child Form

  • Thread starter Thread starter KBFour
  • Start date Start date
K

KBFour

I am working with a local non-profit that works with Seniors and am trying to
revamp their database. I have created several tabs for each type of event
the volunteers or receipients may particiapte in (Education, Travel,
Donations, Committees, Teacher, etc.). I want to be able to create the input
in the main form where they can input there, click ADD and have it populate
the child form that is in a datasheet view. I want to make the child form
read-only so the volunteers that input the data can't accidentally overwrite
any existing data.

My thought was to create a "holding" table that would contain the fields in
the child form/table and use it to run an append query to populate the linked
table/form. Then, I would have the child form refresh to show the new data
and clear to holding table. Not sure if I am heading in the right direction
with this. I would have to create 10-12 of these for each tab for each event
that is tracked.

Any help would be greatly appreciated! Thanks!
 
Yes, I have all the table structure. As an example of the one tab I am
working on now (Committees), tables and relationships are as follows:

tblClient (main table with basic client info)
ClientID
Client Name, Address, etc.
tblCommittee (one to many with tblClient with client committee membership
data)
ClientID
CommitteeName
YearStarted
YearEnded

tblCommitteeID (includes committee name with 1 to many to tblCommittee)
CommitteeID

CommitteeID links to Committee links to Client. The client info is in the
main form with a tab for each event the client may participate in with that
event information in a child form in a datasheet view. Committee is the one
I am working with now, but they will include giving, education, travel, etc.
Each will be unique information linked back to the Client table in a similar
fashion as outlined above for committee.

What I am trying to do is create unbounded text boxes in the tab as part of
the main form that correspond to each field value in the child form (in this
case Committee Name, Date Started, Date Ended) so that when the data is added
to the unbounded boxes and an "Add Data" button is selected, I can run so
kind of append update to add the data to tblCommittee and clear the text
boxes that held the entered data.

This probably has to be done in SQL, but I am pretty much a newbis in that
area. I tried to run it using an append query, but it would do nothing.

Thanks!
 
Back
Top