Tags: access, box, combo, database, form, microsoft, mysql, northwind, note, novice, oracle, property, relative, selection, sql, toaccess, yeshi

combo box not allow selection

On Database » Microsoft Access

5,043 words with 3 Comments; publish: Fri, 30 May 2008 12:24:00 GMT; (250125.00, « »)

Please note: Allow Edit property of form is set to Yes

Hi. Hoping someone can help me - a relative novice to

Access. I'm using Northwind as a working example to

build my database from. I have a table with a lookup

field to another table. The table with the lookup field

is included in a query which links it with the other

table. I then have a form which is bound to this query.

The lookup field works fine in the table itself. In the

form, the records are displayed in the combo box, but

nothing happens when I "click" on a record to select it.

I've checked all the properties and compared them to

Northwind, and nothing seems out of place. Please help.

Thank you

All Comments

Leave a comment...

  • 3 Comments
    • I think you need to add one field to your main table - to store the selection

      of your combo box look up for each record. Make sure that your combo box is

      bound to this <new> field in your main table. Within the combo box lookup

      query, you should reference your actual lookup table. You don't have to link

      them together in a single query. You can't have your record source for you

      main table include your combo box lookups within the query.

      Sam

      "Sue" wrote:

      > Please note: Allow Edit property of form is set to Yes

      > Hi. Hoping someone can help me - a relative novice to

      > Access. I'm using Northwind as a working example to

      > build my database from. I have a table with a lookup

      > field to another table. The table with the lookup field

      > is included in a query which links it with the other

      > table. I then have a form which is bound to this query.

      > The lookup field works fine in the table itself. In the

      > form, the records are displayed in the combo box, but

      > nothing happens when I "click" on a record to select it.

      > I've checked all the properties and compared them to

      > Northwind, and nothing seems out of place. Please help.

      > Thank you

      >

      #1; Fri, 30 May 2008 12:25:00 GMT
    • Sam,

      Thank you so much for your reply - unfortunately I'm a

      bit slow and don't quite follow your suggestions. Here

      is a bit more detail on my set-up:

      Contacts Table has a field Name. Quotes table has a

      field Name which uses a combo box lookup from

      Contacts.Name. The query Quotes Query uses fields from

      both these tables, but only the Quotes.Name field (not

      the Contacts.Name field.

      I have other combos on the same form that are also not

      working, but I have other forms where the combos are

      working.

      Many thanks again,

      Sue

      >--Original Message--

      >I think you need to add one field to your main table -

      to store the selection

      >of your combo box look up for each record. Make sure

      that your combo box is

      >bound to this <new> field in your main table. Within

      the combo box lookup

      >query, you should reference your actual lookup table.

      You don't have to link

      >them together in a single query. You can't have your

      record source for you

      >main table include your combo box lookups within the

      query.[vbcol=seagreen]

      >Sam

      >"Sue" wrote:

      field[vbcol=seagreen]

      query.[vbcol=seagreen]

      the[vbcol=seagreen]

      it.[vbcol=seagreen]

      help.

      >.

      >

      #2; Fri, 30 May 2008 12:26:00 GMT
    • From what you posted, I don't have enough info. to pin-point the problem but

      I think you might have been misled by the LookUp Field.

      See The Access Web article:

      http://www.mvps.org/access/lookupfields.htm

      Get rid of the Lookup Field, decide on the relationship between you Table

      and then implement the ComboBox to select the value of the LookUp *Table* as

      a Field value for the main Table.

      HTH

      Van T. Dinh

      MVP (Access)

      "Sue" <anonymous.ms-access.questionfor.info.discussions.microsoft.com> wrote in message

      news:1e8501c4a890$fe15e020$a301280a.ms-access.questionfor.info.phx.gbl...

      > Please note: Allow Edit property of form is set to Yes

      > Hi. Hoping someone can help me - a relative novice to

      > Access. I'm using Northwind as a working example to

      > build my database from. I have a table with a lookup

      > field to another table. The table with the lookup field

      > is included in a query which links it with the other

      > table. I then have a form which is bound to this query.

      > The lookup field works fine in the table itself. In the

      > form, the records are displayed in the combo box, but

      > nothing happens when I "click" on a record to select it.

      > I've checked all the properties and compared them to

      > Northwind, and nothing seems out of place. Please help.

      > Thank you

      >

      #3; Fri, 30 May 2008 12:27:00 GMT