combo box not allow selection

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

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
 
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
 
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
 
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.
 
Back
Top