Hello all-
I would like to build a form that allows a user to select multiple values from a combo/list box to add to a field in a table. The intent is to create a list of birds that would allow someone to select only the birds in view at a regular interval (e.g., hourly). The options below are where I stand at the moment. I've explored Options 1 and 2, but they have issues...Option 3 is something that I'd like to explore, but need help with:
-Option 1) I've enabled the Combo Box functionality in the field in the _table_, and can select and add multiple values as needed from the form via checkboxes. However, because this form will be used on a 8" tablet in the field (on construction sites), large buttons/fields will be a must. Not being able to enlarge the actual checkbox for the Combo box will make it hard to select the correct value with fingers.
-Option 2) As a test, I also set up a List box (which I can then enlarge the text as needed to make it easier to see/tap) that is supposed to feed into another (test) field, but the values selected in the List Box won't populate the field in the table when I move to a new record. So, from a formatting/GUI perspective this option is better, but the data does not appear in the appropriate field in the background table.
-Option 3) Have the user select multiple values in the List box, then add the values to another field on the same form (ie using a "right arrow" to move the values to the new field), which would then populate the proper field in the table with a click of a button. However, this gets a bit outside of my query building box, and I have not been able to execute this option.
I don't know SQL very well, so if this is the only option, then I will need baby steps. Does anyone have any suggestions? Thanks in advance.
Todd