Combo Box Issue - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Combo Box Issue

Irene Tumulac

4 years ago

Hello Richard and all,
I desperately need help. This is a simple issue but somehow I couldnt get it work. I created this form with combo box. The combo box has name and company name but when I try to create a new record, it is not allowing me to type anything in the combo box to pick any name. It seems block. I attached the pictures so you understand what I'm talking about. I've created this same form before without any issue but this time, I'm not really sure what I did wrong. Please help. Thank you

	Irene Tumulac OP @Reply 4 years ago

	Irene Tumulac OP @Reply 4 years ago

	Scott Axton @Reply 4 years ago
Irene check the Enabled or Locked properties. Both for the form and for your Combo Box control.

	Kevin Robertson @Reply 4 years ago
It looks like a problem with the query the combo box is based on. In the second image it says (New). I think the recordset is Not Updateable.

	Richard Rost @Reply 4 years ago
It would only say (New) like that if the field were bound to an AutoNumber.

	Irene Tumulac OP @Reply 4 years ago
Richard, What do you mean because I still cannot figure out what's wrong with it. I tried different ways.

	Richard Rost @Reply 4 years ago
What field is the combo box bound to? It's Control Source property? Is that an AutoNumber?

	Irene Tumulac OP @Reply 4 years ago
Yes it is. Control Source property is an AutoNumber. Is that the reason why it is not updatable?

	Richard Rost @Reply 4 years ago
Can you change an autonumber?

	Irene Tumulac OP @Reply 4 years ago
I changed and messed with an autonumber, and my form works! Thanks for your help Richard!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View