more than one combobox - accessing one table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to have on a form a way to select from a table of lots of, say
fruit.
Today the user eats an apple, orange and a banana. If I had three combo
boxes reading the same table it carries the same info through all the users.
 
The way I see it, each fruit eaten should be a separate record. You should
use a main form to select the user, with a subform to enter all the fruit
records. Use a combo box in the subform with the fruit selection, select the
first fruit then go to the next new record to select the second fruit, etc.
Make sense?

Con Giacomini
 
Back
Top