Re: Problem: combobox, table lookup, adding new record

Tech-Archive recommends: Fix windows errors by optimizing your registry

Rob

If you are trying to use a combo box and do NOT wish to limit entries to
what is in the list, check the NotInList event in Access HELP.

Note, however, that combo boxes are great for allowing selection of an item
from a list of possibles. You may want to consider some other approach to
showing all the items from one table that are associated with a record in
another table. Usually, a continuous subform does this well.

--
Regards

Jeff Boyce
<Office/Access MVP>

"Rob" <robertborgersen@xxxxxxxxx> wrote in message
news:1137308653.462241.33130@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I have a form for entering "Items" from receipts. Each Item has a
> name, but it also has one or more Short Names -- the names that are
> actually written on the receipt. Here is my problem: I have a nice
> continuous form for entering new items right now, but I want to be able
> to add a short name to an item (since it may have many--the same item
> may have different short names at different stores) on the same form as
> the rest of the items properties.
>
> This is what I was thinking: a Combo Box that contains all the short
> names currently assigned to the current item, with the ability to write
> in an item not in the combobox list, and have it be added to the "short
> names" table for the current item.
>
> I am having trouble figuring out what my control source, row source,
> bound column, etc, should be in this case. Here is the setup:
>
> Item Table
> -ID
> -Name
> -Description
> -etc
>
> ItemShortNames Table
> -ID
> -ItemID
> -Short Name
>
> Again, I want my combobox to contain a list of all the different short
> names assigned to the particular item, inside a continuous form (for
> easy entry and editing of items--so I don't think subforms will work)
> with the ability to type in a new short name in the combobox at will.
>
> Please help. I've been working on this problem for a long time and I
> can't figure it out...it's really slowing me down.
>
> Thanks
>
> Rob
>

.

Relevant Pages

  • Re: Coding Afterupdate of Combobox to modify data shown in Textbox
    ... I needed to remove the Control Source of the Textbox before your code worked. ... But I also said I had a continuous form. ... Below the combobox is a textbox. ...
    (microsoft.public.access.formscoding)
  • Re: Coding Afterupdate of Combobox to modify data shown in Textbox
    ... I needed to remove the Control Source of the Textbox before your code ... But I also said I had a continuous form. ... Below the combobox is a textbox. ... I want to use the Textfield to display the Name, ...
    (microsoft.public.access.formscoding)
  • Re: Dependant combos on continuous form show same value
    ... Me.NameOfCombo.RowSource = "SELECT MyID, MyName FROM MyTable" ... There is another method that is often used to solve this problem, which involves overlaying a textbox on top of the combobox, so that the combobox is only visible when it has the focus... ... But I want to display data in datasheet (or continuous form) view, ...
    (microsoft.public.access.forms)
  • Problem: combobox, table lookup, adding new record
    ... continuous form for entering new items right now, but I want to be able ... I am having trouble figuring out what my control source, row source, ... I want my combobox to contain a list of all the different short ... with the ability to type in a new short name in the combobox at will. ...
    (microsoft.public.access.forms)
  • Re: Coding Afterupdate of Combobox to modify data shown in Textbox
    ... "The Control Source of the Textbox is the Name-field of Table B." ... But I also said I had a continuous form. ... Below the combobox is a textbox. ...
    (microsoft.public.access.formscoding)