Search results

Here's my code... Private Sub Command15_Click() Dim strSelect, strWhere, strFrom As String Dim strNcTool, strNcDiv, strMaterial As String Dim defQuery As QueryDef strSelect = "SELECT [Tooling Information].[NC Tool #], [Tooling Information].[NC Division], [Tooling Information].[Profile #...

KeithG Actually, do need to have that separate table. I noticed if I deleted the info in one of those drop down menus, it deleted that info in the table it was pull from. So I do need a separate search criteria table to have as a pull down menu to make sure no data is deleted. I'm struggling...

KeithG Just curious, to add the drop down boxes to the form you created, do I need my orginal tables "SearchCriteria-Tooling" Table, and the "Result-Tooling" Query that I created?

Ok, I'll try my best to add the info like you said. Would you mind a few more questions if I run into them as I go further into this? Should I post them in this thread or a private message ok? Thanks so much for all your help.

Well, I can't say thank you enough. You really pulled through for me. I truly appreciate the effort. I don't know how long it would have taken me to get this done with your help. And I'll try pay it forward as best I can.

Ok, so what you did in like 10 minutes is what I've been trying to get to work for days now. Thank you very much for that effort. You even applied it to the form I want it in. That rocks. Now I what is the easiest way to add the rest of the items in the Tooling Information form as drop down...

KeithG... Your example is it in a nutshell I believe, Yes. You make that look easy. Could you please explain what you did to do that? My brain is mush right now and even the simplest task right now is getting my blood pressure up.

KeithG... What I'm looking for is a form that has drop down boxes that you can select a set from a list of information entered into a table, that way you don't have to know the exact wording/spelling or any variable of something in that column from a table. If I say have 20 drop down boxes of...

weird thing with the prompts... there is a prompt with just a "T" I don't see a line in the code that should just ask for "T" value though

RuralGuy, Thanks, I'll take a look at that now and see what I can find out.

ok, I get a prompt now when I hit the "view form" button... one step closer...

nevermind, I didn't have "cmb" in the name field of the combo box properties... is the cmb necessary to have in the code, so I could take it out of the code and the name of the combo box?

Yup, I copied and pasted what you had posted. Just trying to change the combo box name in properties, (the very top entry in the properties dialog box)

I've tried changing the name of the fields to remove the space, but I still get the error message... Compile error: Method of data member not found

Quick question... Do I change the name of the field in just the form, or do Ineed to change the name of the field in the original table?

Heck, You've helped me do so much already. NO need to apologize. You know someone that can help to populate to a form? Or do I need to try posting another thread asking how?

Sorry took so long to get that posted. This site must have been having network issues. I couldn't get a page to connect to for forever. Please take a look at that new zip file and see what I'm doing wrong. Thanks again for your patience.

Here you go, I compacted it to get rid of junk and get down to a much smaller size. Sorry for any confusion. I'm not quite sure why that old file was in there.

Trying to repost it, but over the zip file size max.

Hey, you're helping me out. I'll never complain when I'm getting help. Besides, my newbie questions are probably a cause of your headache. Search-Tooling is the name of the form that has "refresh", "run maco" and "view form" button on it. The "refresh" and "run macro" buttons were just to...