Access 2003 Form:Combo Box will not accept any entry

[jwellsnh]

I am using Access 2003 and I am having trouble with a Combo Box on a form.

I had a combo box (based on a table), storing the choice in a field in the query and underlying table the form is based on. Everything was working fine, until... I altered the form based on a query. Now when you make a choice from the drop down list you get an error bell and nothing happens.

[John_G]

Does your form allow updates? (Allow Edits = Yes)

Check the query the form is based on - is it updateable?
If the query is updateable, check the field the combo box is bound to - it has to be a table field, not an expression.

Post back if none of these work.

John

[jwellsnh]

Hi John,

The form does allow updates. The query in question is a Select Query; altered it to be an Update Query but the form refused it and the error message said to make it a Select Query.

What is your means of making a query "updateabel"?

Combo box displays normally; but as soon as you pick a value; the bell rings.

Jeff

[John_G]

Hi -

Ab updatable query is one which when opened will allow you to make changes to the data. Not all Select queries are updatable, for example totals queries, many queries which link more than one table. In some cases, even though a query itself is updateable, calculated fields (i.e. expressions) within it are not.

If you open your form query in design view and then run it, can you edit the resulting data rows? If not, the query is not updateable, and that is the source of your problem.

One other thing to check - might the "locked" property of the combo box be set to "Yes"?

John

[jwellsnh]

Hi -

An updatable query is one which when opened will allow you to make changes to the data. Not all Select queries are updatable, for example totals queries, many queries which link more than one table.

John

John, thanks for the explanation of an updateable query; the source of my issue is a join to another table. Can't say that I am an Access fan boy and it may be time to move this data into Oracle where I have more options.

Thanks for you help.

Jeff