Hi all,
I am very new to made a form in Access so forgive me with limited technical language of Access.
Here is the case.
I have 2 tables
- students_data (with field: ID, name, class)
- late_log (with field: Autonumber, name, ID, late_date)
The idea is to provide one combo box (1) which list classes. After user select one class, there is another list box (2) that list name of students based from class selected on combo box (1)
After that, there will be a button save to save those data (name, ID, late_date) into table late_log.
My questions:
- how to create list box (2) that contain list of students based on class selection
- how to insert todays date automatically into late_date while saving
- how to create a button to save those data?
I am sorry if this is a simple qustion but I dont know where to ask.
Thank you.