Form with multiple entry fields, only fields with values created as new record in table

[JustWonderful]

I have a list of 24 unique items in a table. I would like to create a form that lists all 24 items with a blank entry field alongside each one. I would like to be able to enter a value in these blank entry fields for any number of the 24 items, and have each item name and the value I entered be stored as a single entry in a new table. For example: I enter a value for 15 of the 24 items. I click a button and 15 new records are made to a table consisting of the item name and the value that corresponds to it.



Is there a way for me to create a data entry form this way?

For more context, I'm tracking my daily habits. I've made a table listing all the habits I want to track. I'd like to be able to record values for multiple habits at once and store them in table (along with the date and time that they were entered).

Thanks in advance for your help!

[June7]

Okay, build a table for storing your daily records. Build a form bound to the table. Install controls on form bound to fields. Use a combobox or listbox to select item for saving into record. Textbox for date can have DefaultValue property set to Now() to automatically save the date/time. Move to new record row and create next record.

Basic relational database structure and Access functionality.

Your button click idea to create records requires code. The above suggestion does not need any code.

Have you studied an introductory tutorial book?

[JustWonderful]

Thank you, but the reason for my post is for assistance going beyond a basic combobox data entry form, to one capable of entering multiple records at once. If it involves code that's fine, I just need a push in the right direction.

[June7]

Yes, can be done with code but why bother since the user (you are the only user?) is required to do just about as much work. Either way have to do 15 clicks to select items. But if you must and assuming you are the only user, have a yes/no field (IsHabit) in your Habits table then code in button click event like:

CurrentDb.Execute "INSERT INTO Daily(DtTm, HabitID) SELECT Now() AS DtTm, HabitID FROM Habits WHERE IsHabit"
CurrentDb.Execute "UPDATE Habits SET IsHabit = False"

Or instead of the yes/no field, use a multi-select listbox and that requires more complicated code to loop through the listbox selected items, save records, clear the listbox selections.