Trying to populate table given input from a form

I

ivalum21

Hi there,

I have a database application that is your basic Students - Enrollments -
Classes database. I have also added in a Sessions table because the same
class is offered at different times, and I've also got an Attendance table.
The Attendance table has SessionID, StudentID, and Date as the primary key
(it also has a Yes/No field to indicate if the student was present on the
given date).

Right now there is no information in the Attendance table. I want the user
to run a form that asks them which session they want. They choose a session
and click "Next", when you click "Next" I want the form to populate the
Attendance table with the appropriate information and display it in a new
form where the user can input if a student was present or not.

Any help would be greatly appreciated, I'm really stuck with this one.

Thank you,
ivalum21
 

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

Similar Threads

Using Form to input multiple field to table at once 1
Passing data to a form AND performing append query to table 2
Crating User Form to Add Names 1
Copy previous record into form field 0
Dynamic Naming of Form Button 3
Clearing check boxes when a form closes 5
Continuous Form data entry problems 3
Populate main form from subform record 0

Top