Can't select Combo box

[firefly2k8]

Having a nightmare with this combo box.

Spent ages surfing the web for solutions but nothing working.

I have a form. I have set the record source of the form to the query below which i built to fill my combo box.

I have set the record source property of the combo box to this query too.

Bound column is 1. (ie should be first column)

I have set the control source property of the combo box to "Unique Project ID" which is an autonumber field from the query.

Populates combo with all the data i want, but wont let me select anything!

It is fair to say I don't completely get the point of bound column, record source, control source, row source.

it should be this hard to make a drop down!!

SELECT [SE11 Project Directory].[Unique Project ID], [SE11 Project Directory].[Project Date], [SE11 Project Directory].[Base Currency]
FROM [SE11 Project Directory];

 

[StevenBee]

sorry I don't have an answer to your problem - maybe fiddle with your Column Count and Column Widths... but thought I'd pass on an excellent article that explains these topics well:

office.microsoft.com
/en-us/
access-help/
basing-one-combo-box-on-another-HA001173058.aspx

(sorry it's disjointed - I haven't posted enough to post a link yet)

Hope you find your answer, or someone else can provide you with more help.

 

[firefly2k8]

Thanks for the link. That helped explain some of the concepts. But I still have the problem. I now think it might be an access bug. There was some mention elsewhere on the web of it being a service pack issue. I have SP2, do you think it is worth moving to SP3 due to this?

Has anyone been able to produce a combobox on a table where the primary key is an autonumber, without this freezing problem?

Regards

 

[boblarson]

1. There should be no reason why your combo box should use the same query as your form.

2. Your combo box row source should be from a DIFFERENT table which holds your lookup values.

3. If you have lookups defined at table level, get rid of them as they are not good (see here for why).

4. The recordset has to be updateable for you to be able to select from a combo box if it is bound.

5. The Allow Edits of the form and if it is a subform, the main form too have to be set to YES and/or Allow Additions for adding new records.