For John Vinson

G

Guest

Hi John,

You have helped me incredibly in the past and I have been trying to post
generally and working on my own with Access, plus reading books, etc. You
have been so generous with your advice and I didn't want to become a pest,
but... I'm at the end of my rope of this one.

To refresh your memory, I have the student database. The area where I'm
having trouble is the payment and deposit data.

For Payments:

I would like to create a form with 2 subforms that would populate the
following tables:

*Payment Information Table:
PaymentID - autonumber PK
FamilyID - FK from Family Info table, one-to-many, referential integrity
enforced
Mode (cheque or cash)
Date
Amount
Cheque no

*Payment Allocation Table:
PaymentID - FK from Payment Info table
CourseID - FK from Course Info table
StudentID - FK from Student Info table
- These three fields are the PK of the table
CourseName - will use a bound combo in form to look up from Course Info
StudentName - will use a bound combo in form to look up from Student Info
Amount - will key in amount from Payment Info table

The payment may be split. For example, a payment of $200. may be split
$50.00 for child A in the family per course for a total of $100. and the same
for child B.

I create a form using the wizard that includes the family name from the
Family Info table, plus the fields from the Payment Info. No problem.

The problem arises when I try to create a sub-form and drag it into the
design of the form I mentioned above. I can get the student name combo box,
but it shows the names of all students, not just the ones for the family
involved, I can't seem to tell it which family it should be linking to.

I also will have to populate a Deposit Info table (this means bank deposits
of the money taken in) that will contain the total amount deposited per
deposit number, broken down to total cash deposits and total cheque deposits.
I haven't even attempted this, because I'm struggling with the above.

I hope this is clear enough. Any assistance you could provide would be
greatly appreciated.
Thanks so much.
 
G

Guest

Just to clarify previous post. What I want to achieve is:

Main form - Family Name and ID
Sub form 1 - PaymentID, Date, Amount, Mode, Cheque No
Sub form 2 = PaymentID (I guess) then be able to choose Student Name from a
combo box that limits it to the students related to the FamilyID in Main
Form. I also want a combo box that, again, shows only the courses the
specific student is taking. (This information is in the Enrollment table)

I have no idea how to accomplish this. I know how to create the combo box,
but where to I take the fields from and to.
 
K

Ken Snell [MVP]

John is unavailable for a few days. Linking combo boxes this way is fairly
commonly done.

This article tells you how to tie the two combo boxes together:
http://www.mvps.org/access/forms/frm0028.htm
--

Ken Snell
<MS ACCESS MVP>

dee said:
Just to clarify previous post. What I want to achieve is:

Main form - Family Name and ID
Sub form 1 - PaymentID, Date, Amount, Mode, Cheque No
Sub form 2 = PaymentID (I guess) then be able to choose Student Name from
a
combo box that limits it to the students related to the FamilyID in Main
Form. I also want a combo box that, again, shows only the courses the
specific student is taking. (This information is in the Enrollment table)

I have no idea how to accomplish this. I know how to create the combo
box,
but where to I take the fields from and to.
 
J

John Vinson

Just to clarify previous post. What I want to achieve is:

Main form - Family Name and ID
Sub form 1 - PaymentID, Date, Amount, Mode, Cheque No
Sub form 2 = PaymentID (I guess) then be able to choose Student Name from a
combo box that limits it to the students related to the FamilyID in Main
Form. I also want a combo box that, again, shows only the courses the
specific student is taking. (This information is in the Enrollment table)

I have no idea how to accomplish this. I know how to create the combo box,
but where to I take the fields from and to.

Dee, I've got to leave this morning for a meeting - I won't be back
until Sunday or Monday. Sorry, but I don't have time to figure this
out today!

You may want to start a new thread describing the tables; be sure to
include the Recordsources of the two subforms (that's not clear at the
moment to me) and the logical relationship between the tables.

I'll check in on this thread when I return - if you do get an answer
in another thread, let me know here or by EMail (jvinson <at>
wysardofinfo <dot> com).

John W. Vinson[MVP]
 
G

Guest

Thank you for taking time out of your busy schedule to answer me. I will try
to figure it out and re-post.

Thanks again, John.
--
Thanks!

Dee
 
G

Guest

Thank you, Ken, for letting me know about John. I looked at the link you
suggested very kindly, but didn't find what I was looking for, so I reposted.

Thanks again. I'm getting pretty panic stricken about this. I've spent
about 3 days on it so far and am getting nowhere. I'm sure once I figure it
out, it will be a "duh" moment! :)

--
Thanks!

Dee


Ken Snell said:
John is unavailable for a few days. Linking combo boxes this way is fairly
commonly done.

This article tells you how to tie the two combo boxes together:
http://www.mvps.org/access/forms/frm0028.htm
--

Ken Snell
<MS ACCESS MVP>

dee said:
Just to clarify previous post. What I want to achieve is:

Main form - Family Name and ID
Sub form 1 - PaymentID, Date, Amount, Mode, Cheque No
Sub form 2 = PaymentID (I guess) then be able to choose Student Name from
a
combo box that limits it to the students related to the FamilyID in Main
Form. I also want a combo box that, again, shows only the courses the
specific student is taking. (This information is in the Enrollment table)

I have no idea how to accomplish this. I know how to create the combo
box,
but where to I take the fields from and to.
 
K

Ken Snell [MVP]

What are you doing that is different from what is in that linked article? Or
what were you seeking there that you didn't find?

I read through your first post on this, and I think I'm getting lost in the
forest because of the various items that you describe. Let's focus on just
the specific comboboxes and where they're located.
--

Ken Snell
<MS ACCESS MVP>



dee said:
Thank you, Ken, for letting me know about John. I looked at the link you
suggested very kindly, but didn't find what I was looking for, so I
reposted.

Thanks again. I'm getting pretty panic stricken about this. I've spent
about 3 days on it so far and am getting nowhere. I'm sure once I figure
it
out, it will be a "duh" moment! :)

--
Thanks!

Dee


Ken Snell said:
John is unavailable for a few days. Linking combo boxes this way is
fairly
commonly done.

This article tells you how to tie the two combo boxes together:
http://www.mvps.org/access/forms/frm0028.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top