Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    2

    Unanswered: Relating text field to combo box in a form - need help

    Hi ,
    My table has an ITEM field and a DESCRIPTION FIELD.
    My inventory form has an ITEM field and a DESCRIPTION combo box.
    eg Item : bottle
    Description : 1 Litre
    2 Litre
    5 Litre
    User enter an item in the ITEM field and has an option to enter the description or select from the drop down list in the DESCRIPTION combo box.The drop down list is drawn from the DESCRIPTION field and related to the Item entered. Also the drop down list is unique and does not have repeated description data.
    I have used query but without success. Any help, please.
    Thanks.
    .::
    |-|.: * .:
    .: .:::| _ .:::.:.: .: .:: .::
    .:: |-.:: .::* .:: .:: .:: .:: .::
    .:: |-.::.::*~~~o~.:: .:: .::.:: .::
    .:: |-.:: .::O o *.:: .:: .:: .:: .::
    .:::/__.:: |o.:::__.:: .:: .::
    .::
    |-|.: * .:
    .: .:::| _ .:::.:.: .: .:: .::
    .:: |-.:: .::* .:: .:: .:: .:: .::
    .:: |-.::.::*~~~o~.:: .:: .::.:: .::
    .:: |-.:: .::O o *.:: .:: .:: .:: .::
    .:::/__.:: |o.:::__.:: .:: .::

  2. #2
    Join Date
    Aug 2002
    Posts
    1
    Richie,

    You can create the query as:

    SELECT Table1.Description, Table1.Item
    FROM Table1
    WHERE (((Table1.Item)=[Forms]![Form1]![cbo_item]));

    This is just a generic query with basic names for the objects. Selections from the description combo box are dependent on selections based on choices selected by the user on the cbo_item field on the form. Make sure when you run the query that the form is open and not in design mode to see the query work.

    Hope this helps.

  3. #3
    Join Date
    Aug 2002
    Posts
    2
    Hi,
    Thanks for answering my question.
    What I got is a parameter input on the item and then all the descriptions (both related and unrelated) from the Inventory table.
    However, the item field on the form should be ready to be entered when the form is opened. When he finishes entering the item field he goes to the description combo either to enter the description OR select from the drop down list from the same description combo.
    All descriptions must be unique without repetitions and related to the item entered. The description combo list is drawn from the inventory table. The item and description entered append onto the inventory table and description combo then draws its list from description field in the table to be used, if required, for next new record.

    Thanks.
    .::
    |-|.: * .:
    .: .:::| _ .:::.:.: .: .:: .::
    .:: |-.:: .::* .:: .:: .:: .:: .::
    .:: |-.::.::*~~~o~.:: .:: .::.:: .::
    .:: |-.:: .::O o *.:: .:: .:: .:: .::
    .:::/__.:: |o.:::__.:: .:: .::

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •