auto fill first field in a form

[nickarkal]

Hello

I’m just starting using access 2003 and I need your help to deal with a problem I’m facing. I have 2 tables related to each other. The first contains the names of 30 students and the other a series of useful information that I want to keep every day about them. I made a form for new records entry. Every day I am planning to create 30 new records by using this form. What I want to do is, when I start the first new record of the day, the field named “students names” in the form to be filled by access with the name of the first student from the first table. After completing the first new record I will move to the next (2nd) new record where now access must fill the field “students names” with the name of the second student from the first table and so on, until all the new 30 entries of the day be completed

Any help will be appreciated but keep it simple so that I can understand it!

 

[CBrighton]

It might be easier to just have the form bound to the second table, but with an unbound combobox with the recordsource set to the first table which filters & requeries the form.

That way all the user has to do is select the next student in the combobox and the record displayed in the form changes.

 

[missinglinq]

Actually, this is a classic Many-to-One scenario, with One student having Many daily notes. As such, the standard way would be to have a Main Form/Subform setup.

The Main Form would be bound to the Table holding student names.

The Subform would be bound to the Table holding students' notes.

The two would be linked thru a Control holding a student ID number.

Each day you'd simply navigate from one student to the next, using the Main Form, and make a daily note in the Subform.

Linq ;0)>

 

[nickarkal]

That's exactly what I want to avoid, to navigate from one student to the other. Instead I want access to fill this field on its known following the names in the table "students". Each time someone press the button to create a new record, access will insert the next name from the table "students", thus creating a new record. If the day changes and someone press new record for first time that day, access should start from the begging, which means it will insert the first student name