student account database

[jlmyree24]

Good Morning,

I have limited experience with Access and I'm creating a database form that allows a user to input data for a student fundraiser.



There are approximately 300 students grade 7-12 who can raise money through multiple school sponsored fundraisers. I've created a form that acts as an accounting of each fundraising activity for a student.

Problem #1 - I've attached an Excel spreadsheet of the student names (column 1) & grade level (column 2) to a combobox and want the grade level to autofill in another text box when the student name is selected
Problem #2 - There is a simple calculation to determine student account balance after each credit/debit activity and I also want this amount to autofill when the student name is selected

The goal is that the end user will be able to produce reports on individual student fund-raising activities, fund earned, etc.

I have some programming experience but hope these are simple point and click solutions.

Thanks in advance for any assistance provided.

JM

[June7]

You have a link to a spreadsheet? That linked sheet is the source for a combobox RowSource? Options to display related info in textbox:

1. set combobox as multi-column then textbox ControlSource expression references column index of combobox: =comboboxname.Column(x)
Column index begins with 0. If value is in column 1 the index is 0.

2. include the linked sheet in the form's RecordSource by joining on key fields. Bind textboxes to sheet fields.

Problem#2 not so simple. It is usually a bad idea to save calculated data. Ideally, balances will be calculated as needed using transactions as basis for the aggregate calcs.