I need to add data in a subform.

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

Guest

I have a list of items in one table and a list of categories in another.
There is a one (category) to many (items) relationship.

I have populated the list of items and now want to assign categories. I have
not yet created any categories and would like to create them as I assign them
to items. I need to create a form where either a category could be selected
or a category could be both created and selected.

I have tried various subform techniques with no success.
 
I have a list of items in one table and a list of categories in another.
There is a one (category) to many (items) relationship.

I have populated the list of items and now want to assign categories. I have
not yet created any categories and would like to create them as I assign them
to items. I need to create a form where either a category could be selected
or a category could be both created and selected.

I have tried various subform techniques with no success.
Click to expand...

The most common way to do this is to use a Combo box with code in its
NotInList event to add a new category if the desired category doesn't
exist. Search for "Not In List" at http://www.mvps.org/access for
sample code.

John W. Vinson[MVP]
 
Back
Top