Search Combo Box Inoperative - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Search Combo Box Inoperative

Dwayne Parker

2 years ago

I'm trying to create a combo box to search for a record.

(I'm making my way through the beginner videos, and I just finished Beginner 8 where we talk about this issue.)

So, I tried to put this cool combo box to search for a record on the 'continuous form' that we had completed in a previous beginner lesson. I can "create" the combo box just fine. I can see it and everything. But I can't click on it nor type in the box.

I have attached two photos so you can see what I'm talking about, and the steps I followed.

Thanks!

	Dwayne Parker OP @Reply 2 years ago

	Dwayne Parker OP @Reply 2 years ago

	Sami Shamma @Reply 2 years ago
1)This is based on a Query not a table. That is why it does not ask you to hide the ID. 2) The Query is not Editable (Too complex) that is why you can't edit.

	Sami Shamma @Reply 2 years ago
Combo Box Find Record Combo Access Relational Combo Boxes

	Dwayne Parker OP @Reply 2 years ago
Thanks for your response Sami. I have now based the form on a table. That seems to have resolved SOME of the problems. For example, as I prepare the Combo Box, the Wizard DOES ask me to hide the Customer ID. So all of that is great! However, again, when the Combo Box is created, I cannot type inside the box, nor can I select any of the drop down options. Any clue what could be going on?

	Sami Shamma @Reply 2 years ago
What is the form (Not the Combo box) bound to? Send images of the design of the form

	Dwayne Parker OP @Reply 2 years ago

	Dwayne Parker OP @Reply 2 years ago
Hopefully that helps. If you need anymore screen grabs just let me know.

	Sami Shamma @Reply 2 years ago
here is your problem:

	Sami Shamma @Reply 2 years ago

	Dwayne Parker OP @Reply 2 years ago
Sami - you're a HERO !!!! It worked! I can't thank you enough for working with me through the steps. I learned so much for this mistake. Thank you so much!

Dwayne Parker OP @Reply

2 years ago

One last question on this same topic.

What if you only remember one word in the cell, and that word is not the first word?

I tried searching for the 2nd or 3rd word in the record and I got the error message: 'The Text You Entered Isn't An Item In The List' ' but, as you can see, the word IS, indeed, in the list. It's just not the first word.

What's your take? I just finished Beginner 9, so maybe this is addressed at a higher level? Glad to get your feedback on this.

	Dwayne Parker OP @Reply 2 years ago

	Kevin Robertson @Reply 2 years ago
You will need to remove the ID from the Combo Box and update the WHERE condition in the Macro. In my example below I have used the search box Richard built in class. You will need to know about Wildcards Wildcard Search & Like

	Kevin Robertson @Reply 2 years ago

	Kevin Robertson @Reply 2 years ago

	Dwayne Parker OP @Reply 2 years ago
Thanks so much Kevin. I'll keep this goal on the backburner for now. I haven't even gotten to Macros just yet. I'm just finishing Beginner 9. But thanks for the info, and I'll circle back to them soon.

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

Next Unseen

New Feature: Comment Live View