vendredi 10 avril 2015

How to create a form to submit different records for each day of the week?

I need to create a form in which one can select a week, and then enter in a value for a "goal" for each day of this week in a different text box then submit them all at once. I have very limited experience with unbound forms. It would be extremely helpful is someone could help me work through the following situation that is essentially a simplification of the form I am trying to create: I have 1 table with 2 fields"Date" and "number". I also have a form with 3 controls: "Date" "Today #" and "tomorrow #". I want to set the form up so that you enter a date and 2 values then press a submit button and it enters 2 records into the table: 1 using the "Date" value for date and "today #" for the number, and a second record that uses "Date + 1" for date, and "tomorrow #" for the number. I am pretty sure the code to submit these records would be VBA code behind the submit button but I am unclear on how it should look. Any help would be greatly appreciated. Thanks!


Aucun commentaire:

Enregistrer un commentaire