Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

combo box problem 1

enha0501enha0501 Member Posts: 3
I have a database where users enter the data through access forms.In one of the forms there is a forms that has 4-5 combo boxes to choose from.When the user is clicking the combobox the drop down list appears but it doesnot select any value from the dropdown list.

Its the same with all the comboboxs in that form and the endusers cannot change any data in that form.

Please reply asap.Thanking you in advance.


Comments

  • splansingsplansing Member Posts: 140
    : I have a database where users enter the data through access forms.In one of the forms there is a forms that has 4-5 combo boxes to choose from.When the user is clicking the combobox the drop down list appears but it doesnot select any value from the dropdown list.
    :
    : Its the same with all the comboboxs in that form and the endusers cannot change any data in that form.
    :
    : Please reply asap.Thanking you in advance.
    :
    :
    :
    Check the query you are using for the form. Most likely, you have joined tables together in such a way that the recordset you end up with is not updateable. To check this, go into the query builder for your form source and run the query. Try changing some data in the query results. Look at the status bar while you are pressing a key. If it says "This recordset is not updatable", then you will need to simplify your query so that it is updatable.
Sign In or Register to comment.