ComboBox Properties

From: jilleo (jill_at_armorsecurity.com)
Date: 06/14/04 

Date: Mon, 14 Jun 2004 13:18:36 -0400

Hello-

I keep wanting to put combo boxes on my forms. The combobox looks up data
from a table. The table contains a simple ID and Description. I would
like the description to display on the form, but I would like the ID to be
the stored value in my underlying table.

This is something that can be accomplished with Data Access Pages because
there are properties for ControlSourceproperty, ListRowSource property,
ListBoundField property and ListDisplayField property.

These properties don't seem to exist in forms. Any ideas on this? I can
think of ways to do this with 2 seperate fields, but that looks messy and
inefficient.

Thanks.

Jilleo

Relevant Pages

  • Re: Searching Through ComboBoxes
    ... The name of the combobox is PARID. ... combo boxes are linked to a table which is named Project_Inventory. ... ' This is where you add the code to create the resultset ... Don't forget to add code to close the database object db and the ...
    (microsoft.public.access.formscoding)
  • Re: Searching Through ComboBoxes
    ... The name of the combobox is PARID. ... combo boxes are linked to a table which is named Project_Inventory. ... This is easy for a programmer, but not so easy if you haven't ... ' This is where you add the code to create the resultset ...
    (microsoft.public.access.formscoding)
  • Re: Combo Box
    ... Simply make the other three controls text boxes; ... four synchronized comboboxes, I think you could just bind the first combobox ... reason code, but any more than 2 and it doesn't work. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Need entered value added to list
    ... Did I mention that the combobox 'autofills' an unbound text box on the ... Data is entered into two text boxes. ... ID Number and how do I get these two values (newly entered Employee ...
    (microsoft.public.access.formscoding)
  • Re: Initializing Multiple Combo Boxes
    ... You no longer have your ComboBox'es on a UserForm? ... combobox properties for list range shows only a range of cells, ... > Right now I have a form with two currency combo boxes and I separately ... For Each oCtrl In Controls ...
    (microsoft.public.excel.programming)